Diagnostic

Test-DbaDiskSpeed

Test-DbaDiskSpeed View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Analyzes database file I/O performance and identifies storage bottlenecks using SQL Server DMV statistics Description Queries sys.dm_io_virtual_file_stats to measure read/write latency, throughput, and overall I/O performance for database files. Returns performance ratings from “Very Good” to “Serious I/O Bottleneck” based on average stall times, helping you quickly identify storage issues that impact SQL Server performance.