vendredi 23 janvier 2015

Confused about sys.dm_io_virtual_file_stats num_of_reads/writes column


I'm trying to use the sys.dm_io_virtual_file_stats DMF to generate so IO wait information across a number of my servers. I came across this post by Paul Randall: http://ift.tt/1t77Klr. In it he asked people to respond with the results of this query:



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


My question is why is he using io_stall_read_ms / num_of_reads instead of io_stall_read_ms / num_of_bytes_read in order to get the average. I would think ms/byte would be more informative than ms/read. Which at least in part leads me to believe I don't understand what the num_of_reads/writes columns actually represent.


BOL just says



Number of reads issued on the file.



which doesn't really help me much. I'd appreciate any clarification I can get.





Aucun commentaire:

Enregistrer un commentaire