SELECT DB_NAME(mf.database_id) AS databaseName,mf.physical_name,num_of_reads,num_of_bytes_read,io_stall_read_ms,num_of_writes,num_of_bytes_written,io_stall_write_ms,io_stall,size_on_disk_bytesFROM sys.dm_io_virtual_file_stats(NULL, NULL) AS divfsJOIN sys.master_files AS mf ON mf.database_id = divfs.database_idAND mf.file_id = divfs.file_id
Home
› Uncategorized
Post a Comment
Post a Comment