SQL Server Diagnostic Queries - Part 11

In this video, we are going to cover three queries. These will include Query 27 – Drive Level Latency, Query 28 – IO Latency by File, and Query 28, which is IO Warnings.

This series of videos will go through the complete set of my SQL Server 2019 Diagnostic Information Queries. These queries are available for free at glennsqlperformance.com/resources.

I have a blog post that coincides with this video. It is SQL Server Diagnostic Queries – Part 11, available here: https://bit.ly/35IIqdx

Note: There are separate versions of these queries for every major version of SQL Server starting with SQL Server 2005. The general concepts in these videos are applicable to all versions of SQL Server, Azure SQL Database, and SQL Managed Instance.

⏱️TIMESTAMPS⏱️
0:00 Intro
0:58 Query 27: Drive Level Latency
2:44 Query 28: IO Latency by File
6:14 Query 29: IO Warnings

🔴 Please subscribe for more content like this!


SOCIAL
===============================
📝 - BLOG: https://glennsqlperformance.com/
🐦 - TWITTER:   / glennalanberry  
👥 - FACEBOOK:   / glenn.berry.92  
LinkedIn:   / glberry  

Host, Video: Glenn Berry