Home Forums SQL Server 2014 Administration - SQL Server 2014 Calculating average read/write latency across instance using sys.dm_os_performance_counters RE: Calculating average read/write latency across instance using sys.dm_os_performance_counters

  • I was hoping the 'Base' value that comes up was tracking the IOs or something equivalent so that this formula would work but there doesn't seem to be good enough documentation on what the value actually is to confidently use it.

    Looking at the columns returned by sys.dm_io_virtual_file_stats, it looks a lot easier. You'd have to snapshot the #reads/writes, and the total ms of waits.