Post reply

Quick question on cpu counter in extended events

  • January 19, 2016 at 7:09 am

    #307171

    Afternoon,

    I've been running an extended event session to capture rpc_completed events on one of my SQL 2012 SP2 CU2 instances and have noticed something odd.

    The counter for CPU seems to be reporting a figure of 16000 but the duration for the same event is reporting a figure of 7289. Books Online says that both counters are measured in microseconds since SQL Server 2008 R2 but how could the CPU counter be bigger than the total duration of the query? Or am I missing something?

    Any help or advice would be most appreciated.

    Andrew

  • January 19, 2016 at 7:16 am

    #1852754

    Parallelism.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 19, 2016 at 7:23 am

    #1852761

    D'oh, should have thought about that.

    I've just had a look at the query and it doesn't look like it ran in parallel but that would explain it. I'll go back and see if I can see a parallel execution plan.

    Thanks Gail.

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

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