Possible thread starvation detected!

[mdr227]

Does anyone know what could have caused this error message? It caused our SQL server to lock up (SQL 7) and upon rebooting the server one of our databases is coming up as suspect.

 

[AshleyRickards]

You forgot to post the error message. When you see a database as suspect check the location of the data files(.MDF and .LDF). It's possible the drive letter was changed or files moved etc. Ashley L Rickards
SQL DBA

 

[tlbroadbent]

Check the MS KB article, "PRB: Possible Thread Starvation Detected Message Reported in the SQL Server Error Log" at

http://support.microsoft.com/support/kb/articles/Q262/9/73.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[AshleyRickards]

Opps .. I need another cup of coffee. I have'nt seen that error message before. Thanks Terry. Ashley L Rickards
SQL DBA