sys.dm_io_virtual_file_stats shows high latency for tempdb writes

by Michael Holzheimer   Last Updated November 07, 2017 04:06 AM

We just got a new SAN and I was looking at sys.dm_io_virtual_file_stats to make sure we are seeing an improvement compared to our last SAN. I noticed that all the tempdb files are seeing avg write latencies of about 350ms. This is still an improvement as our last SAN had stats of 1000ms avg write for tempdb in sys.dm_io_virtual_file_stats but not as good as I hoped.

Looking at the win.disk.duration perfmon counter on our tempdb drive for the past three days (since boot) the avg disk latency is < 1ms. Sometimes there are spikes to 150ms for one interval (30 seconds).

Looking at our SAN's monitoring tools it says the LUN has an avg write latency of 0.5ms.

VMWares stats are pretty much inline with the win.disk.duration perfmon counters.

Any pointers to where I should look at next to work out what is causing the discrepancy between Sql Servers io stats and perfmon/vmware/san monitoring stats?

Tags : tempdb waits

Related Questions

Sortspill in system stored procedure in merge repliction

Updated September 22, 2017 09:06 AM