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.