SQL Server Performance

Mismatch between sql profiler and perfmon

Discussion in 'Performance Tuning for DBAs' started by Arise, Mar 15, 2008.

  1. Arise New Member

    When using sql profiler I see various sp's coming along with a cpu time of around 500ms, however when I look at the processor usage in perfmon, it hovers at around 5%. What could cause this ?
    Arise, Mar 15, 2008
    #2

  2. ndinakar Member

    If a stored proc takes 500 ms doesnt necessarily mean it caused cpu hike..it just took longer to execute..not necesarily at high cpu..
    ndinakar, Mar 16, 2008
    #3

  3. Arise New Member

    What would cause something like this ?
    Arise, Mar 17, 2008
    #4

  4. satya Moderator

    Could be any other processes running on SQL Server, such as schedule jobs or bulk insert or even anti virus scan during that time.
    Just capture SP_WHO2 to see what other processes are running and consuming the CPU.
    At the moment if there is no performance issues then just ignore, continue the database maintenance tasks to keepup the performance.
    satya, Mar 17, 2008
    #5

Share This Page