Community

What Virtual Filestats Do, and Do Not, Tell You About I/O Latency

(Erin Stellato) One of the first things I look at when I’m troubleshooting a performance issue is wait statistics via the sys.dm_os_wait_stats DMV. To see what SQL Server is waiting on, I use the query from Glenn Berry’s current set of SQL Server Diagnostic Queries. Depending on the output, I start

Read More - Register for Free Membership