SQL Server 2005 became "no responding" until I restart windows 2003

Question

question

limitha asked Feb 22, '13

SQL Server 2005 became "no responding" until I restart windows 2003

9.00.5292.00 - Enterprise Edition (64-bit) and windows 2003 SP2 (64-bit)

sql-server-2005

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2013-02-25T13:43:03Z

Grant Fritchey answered Feb 25, '13

By "no responding" do you mean that you can't connect to it in any way? Or do you mean that some queries won't return? Or do you mean that some users are reporting it as blocked? Remember, we're not sitting in your chair, so being as clear as possible with the question will make it more likely to get an answer that's useful to you. If you can connect to SQL Server, use sys.dm_exec_requests to understand what is currently running on the machine and how much resources are being used and if there are blocked processes.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2013-02-22T10:23:53Z

ramesh 1 answered Feb 22, '13

Any error in the SQL Server Error log or Event Viewer, any blockings on the server ,

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

limitha commented · Feb 22, 2013 at 10:27 AM

i am not getting any error in the SQL Server Error log or Event Viewer, no blockings on the server. i have monitoring the PERFORMANCE DASHBOARD tool in that also memory usage and every thing showing good. And RAM size is 64 GB.

0 ·

question