Friday, February 28, 2014

Custom SQL Server IO Report for Quest/Dell Spotlight

As was the case with my CPU report, I wanted a better way to tap into my Spotlight data to investigate IO data.  I figured I would share the RDL.

Here is my initial version - I'll probably update it to highlight anomalies, but that may take a bit of time to determine and develop.  You may want to adjust the retention of such data within Spotlight itself - this report is based off the default retention.  It happens to be data from a data warehouse server that loads data at night - pretty interesting!

Thursday, February 27, 2014

RDL for Ola's Index Maintenance Logging

Here is the RDL for this report - I moved it to Google Drive.

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.