I am attempting to identify CPU utilization for a SQL server over a long period of time, at a minute by minute level. If our server every hits 95% that causes application issues. I am therefor attempting to right a report that gives me what SQL utilization was over a period of time, not an average over long periods.
Is there a canned report? If not, is the data still stored, and if so for how long back? How would I go about creating a report to give me processor utilization per minute for the whole week.. Or to find all minutes where processor utilization was over 75%...
Thanks!