Scenario
Your CPU utilization is maxing out and you want to find how what is responsible for the high CPU. Sometimes the process is obvious in that you can look at task manager to see who is using the most CPU, but that alone doesn't give you a snapshot of what is happening on your server over a period of time.To begin, use the instructions from this article to capture perfmon data while you are experiencing the high CPU state. Let it capture a decent amount of time so that you can see trends.
After you capture the perfmon data, open it up by double clicking on the appropriate .blg file in the C:\Perflogs folder. You should see something like the above image. Unfortunately, this image isn't terribly helpful. So we will need to remove all the counters and then start by adding counters systematically.