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?