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!
November 28, 2005 11:19 PM
November 29, 2005 4:34 PM