November 2, 2012 at 10:03 am
I've been using perfmon to gather the usual stats on a problem server. Problem as in the user is demonstrating unacceptably slow performance. I'm trying to isolate if this is SQL, the app, or something else & what would therefore, help to resolve.
Amongst other things I've noticed %processor time overall total is 13%. But for 1 CPU of the 8, I'm seeing consistent & prolonged spikes of 80-90%.
How can I isolate what is running on which CPU, how can I troubleshoot or rule out if this 1 CPU is related to the issue?
Sometimes a keyword or a pointer is enough for me to get googling in the right direction so I do appreciate any help in this.
November 4, 2012 at 4:40 pm
Cores or physical by defining "CPU" as you use it?
Is this a dedicated SQL box or are other applications running?
Do you have any settings for max degree of parallelism on either the server or explicitly defined in any of the SQL object code being executed?
Do you have any SQL agent jobs that kick off with execution time stamps patterns that match your CPU spike patterns?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply