IOLatency

Get-DbaIoLatency

Get-DbaIoLatency View Source Patrick Flynn (@sqllensman) Windows, Linux, macOS Synopsis Retrieves I/O latency metrics for all database files to identify storage performance bottlenecks Description Queries sys.dm_io_virtual_file_stats to collect detailed I/O performance statistics for every database file on the SQL Server instance. Returns calculated latency metrics including read latency, write latency, and overall latency in milliseconds, plus throughput statistics like average bytes per read and write operation. Essential for diagnosing slow database performance caused by storage bottlenecks, helping you identify which specific database files are experiencing high I/O wait times.