SELECT b.name,c.name,c.physical_name,
a.num_of_reads,a.num_of_writes,
a.num_of_bytes_read,a.num_of_bytes_written,
a.io_stall_read_ms,a.io_stall_write_ms,
a.io_stall
FROM sys.dm_io_virtual_file_stats(NULL, NULL) a,
sys.databases b,sys.master_files c
WHERE a.database_id=b.database_id
AND a.file_id=c.file_id
AND a.database_id=c.database_id |