March 16, 2012 at 10:50 am
I'm trying to diagnose and fix recurrent slowness in my SQL Server 2008 database. Periodically, generally about twice a minute, the CPU will spike to 100% for 5-15 seconds, sometimes more or less. I've read a bit on SQL Profiler, but am still having trouble reading the profiles I get.
Basically, I have 2 processes, which I distinguish in the profile by LoginName. This morning during a busy spell, I captured 28 seconds of activity. I then selected the LoginName and CPU columns of all the records and copied them to Excel so I could sort by LoginName. With the 2 processes separated, I summed up CPU values for each process. One came out to 9167 and the other to 78531.
CPU's unit is supposedly milliseconds, so it would look like the two processes together used almost 90 seconds of CPU in 28 seconds. How can that be?
March 16, 2012 at 11:15 am
on multi core machines each core reports their usage time. so 3 cores at 28 seconds is roughly 90 seconds. add a couple of other cores doing a little work and you get to the 90 seconds of cpu time in 28 seconds of time. just like if 3 people work on something for 3 hours you have 9 man hours worked.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 16, 2012 at 11:17 am
Makes sense. Thanks so much!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply