Jun 232015

http://www.mssqltips.comThank you all for attending my MSSQLTips webinar today with Sumeet Bansal from Tegile Systems! In the presentation, I made reference to a disk stall collector that you can use to help collect and store database file-level latency statistics into a database for future reference, as well as an aggregation script that analyzes the metrics to provide a percentile analysis of the storage performance trends. These metrics can be presented to a storage administrator to help you demonstrate latency trends and help identify any performance challenges.

Teglie-Logo-Blue-Transparent-smallThe scripts are available for you to download and execute here.

Disk Stall Collector Instructions

Disk Stall Collector Setup

Disk Stall Collection Aggregation

In addition to the disk stall collector, which collects disk latency metrics at the SQL Server level, you can also use Perfmon to collect raw data at the Windows layer. I have a Perfmon setup guide on this site that you can use to set up Perfmon for 24×7 collection to overlay Windows-level statistics with the SQL Server-level statistics from the disk stall collector. Check out the guide here!