Wednesday, February 19, 2014

Custom SQL Server CPU Report for Quest/Dell Spotlight

I often share some of the custom SSRS reports I've created and this one seemed like a pretty good candidate.  It's a custom CPU report by hour that is driven from data collected by Quest/Dell Spotlight for SQL Server.  While Spotlight does have an SSRS Reports Pack, I don't find them particularly useful.

The first thing you need to do to make this report useful is to change the frequency in which the data is harvested and extend the retention.  Since the report has hourly intervals, I decided to store the data every 15 minutes so I can get a descent sample to then average for each hour, respectively.

Now you just have to create the SSRS report and update the data sources in the report.  You can get the RDL here.  This is what the report will look like once you get the plumbing all hooked up - note I'm only displaying Monday through Friday because I've found that my servers are pretty quiet on the weekends.