Post reply

SQL Sever Hangs

  • February 4, 2008 at 6:05 am

    #69558

    Hi All,

    We are getting the error msg (Error: 0, Severity: 19, State: 0) since four day. Our application hangs and all the users get the sql server conncetion error.

    We are using SQL2K with SP4 and our databse size is 15GB. We have alreday make the connections unlimited in SQL sever properties>connctions>Maximum Concurerent user=0.

    We have enough disk space for the database and we have already database maintanance plan with shrink databse.

    I am wonder why I get this error.

    Can anybody help me out for this.

    Thanks in advance.

    Zia Khan

  • February 4, 2008 at 6:28 am

    #774716

    Is that error written into the SQL error log? What's the message that you get?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 4, 2008 at 6:36 am

    #774721

    Yes I get this error in SQL Server log. I also get the following warring msg.

    WARNING: EC 612b94d8, 0 waited 300 sec. on latch 50314bcc. Not a BUF latch.

    Thanks for reply

    Zia Khan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply