Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2005 stopped response Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 5:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 31, 2014 9:19 AM
Points: 11, Visits: 117
We have a SQL 2005 sp4 32bit cluster in windows 2003 standard. Occasionally, Users were not able to make new connection including sa and SQL was very slow, after a while (can be 10 mins or hours), SQL stopped response and failed over, It happened pretty often. I saw the a lot following message in the log:



SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems.

I did some monitoring during it happened, CPU usage is high, DISK IO is good, and did not see memory pressure. I found very high ASYNC_NETWORK_IO waits both in count and average wait time.

any suggestion or fix? I saw some other people had the same issues, but did not see right fix.

Thanks
Post #1430156
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse