This report is one that a SQL guru here created to allow us to find out how much on average a CPU on a server grows over the past 30 days. We created this because we want to know for scenarios whereby the CPU was on average around 20% utilised at the start of the 30 days but is now 80% utilised for some reason. Any massive jump in the average will probably indicate a problem with an application on the system.
We created it as a stored proc and also setup indexes to make it search much faster.
Give it a try and let me know if you have any suggestions.