SQL Server Slowdown
I'm running SQL Server 2000 with Windows 2000 Server on a Xeon multiprocessor system with 3 GB RAM. We've been experiencing slowdown and excessive CPU utilization of system processes with very little user activity. Upon our investigation of the CPU utilization by kernel - using the Kernrate Viewer, both ntoskrnl and hal.dll are showing heavy volume. We don't see the heavy CPU utilization when SQL server is stopped - and do see it when it's running. My concern is that SQL may not be configured correctly to run on our multiprocessor system. What can I do to troubleshoot this? Any help is greatly appreciated!
Software/Hardware used:
Software/Hardware used:
ASKED:
November 28, 2005 11:19 PM
UPDATED:
November 29, 2005 4:34 PM
Answer Wiki:
Hi Rk,
A shot in the dark here, but do you have Hyperthreading enabled on htis machine? We have a client who experienced the same problem.
Here's a link that may be helpful...
http://news.zdnet.co.uk/hardware/chips/0,39020354,39237341,00.htm
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
