Disk IO Latency check

create procedure disk_IOcheck

as begin

SELECT

 DB_NAME(filestats.database_id) AS DBName

 ,files.name AS LogicalFileName

 ,files.physical_name

 ,num_of_reads AS NumberReads

 ,num_of_writes AS NumberWrites

 ,num_of_bytes_read AS BytesRead

 ,num_of_bytes_written AS BytesWritten

 ,io_stall_read_ms AS IOStallReadMS

 ,io_stall_write_ms AS IOStallWriteMS

 ,io_stall_read_ms/num_of_reads as Avgreadtransfer

 ,io_stall_write_ms/num_of_writes as Avgwritetransfer

FROM sys.dm_io_virtual_file_stats(-1,-1) filestats

INNER JOIN sys.master_files files

  ON filestats.file_id = files.file_id

  AND filestats.database_id = files.database_id

ORDER BY num_of_writes DESC

end