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!