SQL Server Performance


Discussion in 'Performance Tuning for DBAs' started by rbold, Nov 24, 2003.

  1. rbold New Member

    I'm running SQLServer 2000 SP3 on a Compaq DL380 with dual Xeon 2.8GHz processors. The server has hyperthreading enabled so to the OS and SQLServer it looks like a quad processor machine. However the overall processor usage is usually stuck at 25% SQLServer, 75% System idle process so can I get SQLServer to use more CPU? In SQLServer Properties, four processors are listed and all are ticked, and the "Use all available processors" option is set.
    Any help gratefully received!
  2. satya Moderator

    Do you have any performance issue so far?
    Try to capture counters for Physical disk, Processor from PERFMON.
    Satya SKJ
  3. joechang New Member

    one reason it might be "stuck" at 25% is that you are running only a single process (that is generating significant load) and that process is not running a parallel plan.
    hence, you can load only one of the processors for 25%. it might appear that the load is on more than 1 cpu, but that would be just because its moving from one to another.
    what is it that you are doing that you want higher cpu?

Share This Page