Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Profiler distribution of grouped CPU seems odd Expand / Collapse
Author
Message
Posted Monday, August 19, 2013 6:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 10:09 AM
Points: 4, Visits: 41
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?
Post #1486079
Posted Tuesday, August 20, 2013 3:45 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 1:24 PM
Points: 805, Visits: 722
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.

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1486460
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse