Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002
    Location
    Nashville, TN
    Posts
    2

    Unanswered: 4 CPU Utilization Imbalance

    Got a strange thing happening, any comments are appreciated:

    1) 4 CPU server
    2) CPU's 0 & 2 are usually below 15% or so utilization (Perfmon, Task Manager)
    3) CPU's 1 & 3 are usually nearly maxed out above 90%
    4) Two SQL threads of over 80 threads in Perfmon show almost constant 90% Processor Time
    5) Processor affinity in Server Properties is checked to use all four processors
    6) Hyper-threading is not enabled
    7) SQL Server priority is checked on HIGH
    8) Dedicated SQL Server

    Anybody know how to track down what those specific threads are executing? Any ideas, anybody? Thanks for the help!

    Steve

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to this link for useful DBCC commands and capture the events.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jan 2002
    Location
    Nashville, TN
    Posts
    2

    4 CPU Utilization Imbalance

    Satya, thanks for the reply, and the link to the highly useful web site. I was able to trace the thread activity using Perfmon and sysprocesses; successfully killed a couple non-responsive threads and things returned to normal. I appreciate the help!

    Steve

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True, keep in touch with the link provided for the tips and tricks on the performance.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •