How Fast and Robust Is Your Storage? - Professional SQL Server 2005 Performance Tuning - page 419

Table 12-1: Output from sys.dm_io_pending_io_requests

io_completion_request_address io_type io_pending_ms_ticks io_pending

0x161D0C08 disk 328 1

0x161ECB78 disk 328 1

0x161CBEF0 disk 328 1

0x164C3FD0 disk 312 1

0x161AEC00 disk 203 1

0x161C9C68 disk 203 1

io_completion_routine_address io_user_data_address scheduler_address

0x01042572 0x071B3168 0x006DC040

0x01042572 0x071819A4 0x006DC040

0x01042572 0x071C4404 0x006DC040

0x01042572 0x0717CCC0 0x006DC040

0x01042572 0x073AAB7C 0x006DC040

0x01042572 0x0740AFF8 0x006DC040

io_handle io_offset

0x00000AC4 3948134400

0x00000AC4 4011196416

0x00000AC4 4011524096

0x00000ACC 8559542272

0x00000AC0 547766272

0x00000AC0 547946496

Then, find what files you have for a given database:

Select * from sys.database_files

Now run the query for the database and file you are interested in:

Select * from sys.dm_io_virtual_file_stats (DB_ID('tempdb'),2)