Windows Forum

Ask something
Discussion Locked

NT 4.0 Server Receives back screen

0 helpful
5 replies

by robert_36117

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
What utilities or programs are available to determine what causes a NT 40 service pack 6a server running SQL server to unexpectly stop processing or only process 1/10 of its normal work load. It must be rebooted in order to return to working conditions. How can it be determine which app is causing this problem

5 replies

by joseph moore

Try using SQL Profiler. It can trace what SQL is doing, and you can get an idea where the fault is.
Also, take a look at Performance Monitor, at some of the SQL Server counters. You might find something there.

by garetjax

In addition to SQL Profiler tool mentioned, you could also use the Windows Task Manager "Process" tab to look for wayward processes using more CPU or memory than they should. Take a snapshot of the process CPU/RAM usage at boot and again when the server gets slow.

Also have you tried stopping/starting the SQL Server services to see if they resume normal "speeds" without rebooting? What version of SQL Server are you running with what service pack?

Hope this helps.

This discussion is closed to new replies.