General discussion

Locked

NT 4.0 Server Receives back screen

By robert_36117 ·
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

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

NT 4.0 Server Receives back screen

by Joseph Moore In reply to NT 4.0 Server Receives b ...

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.

Collapse -

NT 4.0 Server Receives back screen

by robert_36117 In reply to NT 4.0 Server Receives b ...

The question was auto-closed by TechRepublic

Collapse -

NT 4.0 Server Receives back screen

by garetjax In reply to NT 4.0 Server Receives b ...

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.

Collapse -

NT 4.0 Server Receives back screen

by robert_36117 In reply to NT 4.0 Server Receives b ...

The question was auto-closed by TechRepublic

Collapse -

NT 4.0 Server Receives back screen

by robert_36117 In reply to NT 4.0 Server Receives b ...

This question was auto closed due to inactivity

Back to Windows Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums