Top 50 CPU growth  - last 30 days

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.

Thanks,

Chris.