asked
connection timeouts in sql server 2000
Hello all, Happy new year!!! we are having few sql2000 instances. Recently we are facing the connection timeouts and all the applications connecting to SQL Server are getting hanged. After the server restart, everything seems normal.. only thing i got from the cient team is ... [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00] [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00] [382] Logon to server '(local)' failed (JobManager) [298] SQLServer Error: 11, General network error. Check your network documentation. [SQLSTATE 08001] what might be the cause ?? may I please How to dig into this issue ?
There could be a number of different causes. It could be resource related. Meaning a process, or processes, used up all the resources, such as memory, preventing further connections. You'll have a hard time tracking this down after the fact. You need to check what resources are being used by which processes and if that is causing excessive blocking or delays by using sp_who2 at the time of the issue. If not that, then it's possible it's something to do with the OS or with hardware. As @ThomasRushton says, check the windows events log for errors as a starting point.
11 People are following this question.
