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!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!