3 Ways to Prove Your SQL Server Storage is Slow

Thanks for attending my session. Here are the resources:

• The slides (PDF)
• Download the free First Responder Kit or get it from Github

Then, to prove your SQL Server’s storage is slow:

1. Wait Time with sp_BlitzFirst @SinceStartup = 1
   In the Wait Stats section, look for PAGEIOLATCH (reading data pages from data files) or WRITELOG (writing changes to the transaction log files). Here are the audience’s answers from the webcast.
2. File Latency with sp_BlitzFirst @SinceStartup = 1
   But this time, in the File Stats section, look at the Avg Stall (ms) column: that’s how long your storage is taking to respond to requests. Here are the audience’s answers from the webcast.
3. Backup Speeds with sp_BlitzBackups
   Look at the AvgFullBackupThroughputMB column. That’s how many megabytes per second your server is able to back up – although it doesn’t tell us whether it’s a problem with the databases’s read speeds or the backup target’s write speeds. Here are the audience’s answers from the webcast.

Hope you enjoyed the session! If you want to learn more, I’ve got classes on How I Use the First Responder Kit, Fundamentals of Database Administration, and much more.