JeepHound (7/22/2014)

---

Could it be AVG write stall like I use in the below query? With 2 out of 16 of my instances I get high write stall in the 1500 range too with similar SAN array. Most other instances get 5-15 response time.

SELECT

(1.0 * stats.io_stall_write_ms / stats.num_of_writes) AS avg_write_stall_ms

FROM sys.dm_io_virtual_file_stats(2, NULL) as stats

INNER JOIN master.sys.master_files AS files

ON stats.database_id = files.database_id

AND stats.file_id = files.file_id

WHERE files.type_desc = 'ROWS'

and name = 'tempdev'