Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: sys.dm_io_virtual_file_stats

    Please run the following and can see I/O statistics of each database file

    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_bytes

    from sys.dm_io_virtual_file_stats(5,null) as divfs

    join sys.master_files as mf

    on mf.database_id =...

Viewing post 1 (of 1 total)