Hello everyone, I need your inputs on SQL Server CPU utilization. My server details is as below. Manufacturer DELL System Type X86-based PC Model PowerEdge 6650 OS Name Microsoft(R) Windows(R) Server 2003, Enterprise Edition System Function Production-SQL Server 2000 Enterprise Edition CPU Quad xeons, 2.9 GHz,8(HyperThreading) Memory 16GB(AWE Enabled) HDD 146GB, RAID 10 I can see all below performance counter under normal limit SQL Server: Buffer Manager: Buffer Cache Hit Ratio,SQL Server: Memory Manager: Total Server Memory(KB),SQL Server: Memory Manager: Target Server Memory(KB),Physical Disk: % Disk Time,Physical Disk: Avg. Disk Queue Length,Processor: % Processor Time,Process --> % Processor Time ,System: Processor Queue Length But whenever I am seeing Process(sqlservr)% Processor Time which is arising around 200% which i can see a kind of load on SQL Server. Please suggest me what need to be done to reduce process(sqlserv) to less than 100% note that when I run Process(_Total)% Processor Time I can see value up to 800% but my main CPU counter i.e. Processor(_Total)% Processor Time is around 20%. Due we consider this as a CPU bottleneck ? Also For Process(sqlservr)% Processor Time counter : I understand to arrive at average percentage of CPU utilization we need to needs to be divided by the number of processors. Does it mean physical CPU or CPU including hyperthreading ? in my case i have 4 physical CPU with hyperthreading, Do i have to divide it by 4 or 8 ? I am not sure. Please give your suggestion.