SQL Server Performance

CPU Utilization

Discussion in 'Performance Tuning for DBAs' started by SQL2000DBA, Aug 21, 2008.

  1. SQL2000DBA New Member

    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.
  2. Luis Martin Moderator

    First I suggest to not use HT.
    Second, sqlsrv is using 200%. But you have 4 processors so 50% of total power. (no HT).

Share This Page