Profiler distribution of grouped CPU seems odd

  • Greetings,

    I am trying to chase a high CPU load coming from SQLSERVER and wanted to isolate transactions by CPU but noticed the following grouped values BY CPU for a small trace duration;

    CPU

    ----

    NULL = 142

    0 = 84883

    15 = 198

    16 = 273

    31 = 1

    32 = 1

    46 = 1

    47 = 3

    234 = 3

    Question, I know that CPU is in milliseconds but the distribution of values seems to small Often when I trace in my development environment I see total distinct values of 0,15 and 16. Is that saying that no specific statement is taking more than 16/1000 of a second to complete? What about 0 values, to fast to register?

  • I guess this is related to the fact that the datetime data type has a resolution of 3.33 ms. I have noticed that when measuring duration with getdate(), that I never see values < 13 ms.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

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

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