Ad Widget

Collapse

How to monitor the CPU% used by Sqlservr.exe and SQLAGENT.exe?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pepin20
    Junior Member
    • May 2012
    • 13

    #1

    How to monitor the CPU% used by Sqlservr.exe and SQLAGENT.exe?

    Hi guys!

    How to monitor the CPU% used by Sqlservr.exe and SQLAGENT.exe?

    I am using the following parameters, but the details are incorrect:

    Code:
    perf_counter[\Process(SQLAGENT)\% Processor Time]
    
    perf_counter[\Process(sqlservr)\% Processor Time]
    Any help? I think what I'm doing wrong ...

    Thanks for replying.
  • MrSol
    Junior Member
    • Jul 2012
    • 7

    #2
    You will have to divide the values by number of cores. Otherwise you'll get values over 100%.

    Comment

    Working...