Time for another survey!

This survey’s very simple: run the following code on as many of your production instances as you can, and post a comment with the results or send me plain text/spreadsheet output in an email. Please do not add any more info to the results (like server name, commas, lines) as it’s not relevant for this survey and adds a bunch of time to the results processing.

Results are good until 9/6/13 at least – keep ‘em coming!

SELECT
	[database_id],
	[file_id],
    [ReadLatency] =
		CASE WHEN [num_of_reads] = 0
			THEN 0 ELSE ([io_stall_read_ms] / [num_of_reads]) END,
	[WriteLatency] =
		CASE WHEN [num_of_writes] = 0
			THEN 0 ELSE ([io_stall_write_ms] / [num_of_writes]) END
FROM
	sys.dm_io_virtual_file_stats (NULL, NULL)
WHERE
	[file_id] = 2 OR [database_id] = 2;
GO

 

database_id file_id ReadLatency          WriteLatency
----------- ------- -------------------- --------------------
1           2       0                    2
2           1       0                    6
2           2       0                    1
3           2       7                    9
4           2       10                   0
5           2       1                    1
7           2       6                    1
8           2       15                   55
9           2       13                   59
10          2       0                    0
11          2       44                   8


I’ll editorialize the results in a couple of weeks.

Thanks!