Hi all, I know you all gonna direct me to to memory issue, with below error. But would like to know if there is any time beeing, fix for this issue, without restarting SQL Server. Error: Event Type: Error Event Source: MSSQLSERVER Event Category: (4) Event ID: 17189 Date: 7/21/2010 Time: 6:49:43 PM User: N/A Computer: XX XXX XXX XXXX Description: 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. [CLIENT: 11.111.111.11]
Like the message says - "Check the SQL Server error log and the Windows event logs for information about possible related problems."
Also it would help to find out when & what time this happens, such as during backup or any reindex jobs or so. I guess this is a 32-bit environment and confirm the server configuration too.
Just following up to see what is the available physical memory on the server and also the value that is allocated to thsi SQL instance?