SQL Server Performance

Underutilised hardware

Discussion in 'Performance Tuning for Hardware Configurations' started by David_Cheal, Aug 10, 2004.

  1. David_Cheal New Member

    I discovered this forum and was wondering if anyone might be able to help with my problem. I hope this post is no to long.

    We have SQL 2000 STD on Windows 2000 STD server that will not utilise more than 50% of its CPU. The system is running database lookups against 1.5 million records using 30 threads.

    Some details;

    Performs 55,000 index searches a sec
    300 Full Scans a sec
    Buffer cache hit ratio 99.97%
    Total server and Target server memory at 1.6 GB
    No deadlocks sec = 0
    Average wait time = 0

    4 x CPU#%92s at average processor time of 50% each

    We have slowly increased threads and can not get the job to process faster or use the remaining 50% of CPU.

    Any ideas?

    David
  2. Twan New Member


    Hi David,

    Are you saying that your CPUs never peak past 50% or that the average over the length of the job is no more than 50%? If the latter than are you sure that the load warrants more processing power? What is the load that you are trying to put on it? Some statements can only run on a single processor...

    Cheers
    Twan
  3. satya Moderator

    I don't see any problem with the collected stats as the Buffer cache hit ratio is on higher %age.
    Check as mentoned by Twan and refer the execution plan for the queries that are running in this job.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. Luis Martin Moderator

    Is box SQL dedicated or are others applications working?

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page