question

Tim avatar image
Tim asked

Strange CPU Graph

Came across a weird CPU graph on one of my database servers. It is a dual socket quad core machine with hyper threading enabled. The box is dedicated for SQL and SSIS. This graph looks more like a seismic graph than CPU. Any thoughts or has anyone encountered something like this before. What is unique is even the kernel shows the same seismic wave. ![alt text][1] [1]: /storage/temp/402-weird_graph.png
sql-server-2008performancecpu
weird_graph.png (9.1 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Grant Fritchey avatar image
Grant Fritchey answered
Two of those processes look pretty normal, up & down, whatever. The rest... it really looks like there's something scheduled occurring there. I'd capture more metrics using perfmon to see better what's occurring. I'd also check the wait stats.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Cyborg avatar image
Cyborg answered
Is this something the schedulers are not evenly loaded? what are the values of load_factor in sys.dm_os_schedulers?
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image Tim commented ·
load_factor 0 = 1, 1 = 6, 2 = 7, 3 = 7.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.