Friday, April 20, 2012

Disk I/O on SQL Server

To get a pending request longer than 10 milliseconds on your SQL Server  use

SELECT * FROM [sys].[dm_io_pending_io_requests] WHERE [io_type] = 'disk' AND [io_pending_ms_ticks] > 10


No comments: