One of 4 processors getting beat to death

  • Perfmon continually shows one of the four processors staying in the 90 to 95% utilization range, while the other three seem to average about 30 to 40%.

    Granted, there are about 12 different databases on this cluster and with Profiler it points out that our biggest and most used database is what is causing the run up on that one CPU.

    Is it wrong to think that the workload should be more spread out over the processors rather than just one getting punished?

    Studdy

  • what SP are you running? :

    select severproperty('ProductVersion'), serverproperty('ProductLevel')

     


    * Noel

  • Service Pack 3 for SQL 2000.

    Wondering if I need to lower the parallel query processing time from the default of 5 to about 2? 

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply