???????е???????????????????е??????????????????????????￡??е???????????????????I/O???????????????MS SQL Server?????Щ????????????????????????????I/O?????
????1??sys.dm_io_virtual_file_stats

 

SELECT  DB_NAME(vfs.database_id) AS database_name ??
vfs.database_id ??
vfs.FILE_ID ??
io_stall_read_ms / NULLIF(num_of_reads?? 0) AS avg_read_latency ??
io_stall_write_ms / NULLIF(num_of_writes?? 0) AS avg_write_latency ??
io_stall / NULLIF(num_of_reads + num_of_writes?? 0) AS avg_total_latency ??
num_of_bytes_read / NULLIF(num_of_reads?? 0) AS avg_bytes_per_read ??
num_of_bytes_written / NULLIF(num_of_writes?? 0) AS avg_bytes_per_write ??
vfs.io_stall ??
vfs.num_of_reads ??
vfs.num_of_bytes_read ??
vfs.io_stall_read_ms ??
vfs.num_of_writes ??
vfs.num_of_bytes_written ??
vfs.io_stall_write_ms ??
size_on_disk_bytes / 1024 / 1024. AS [size_on_disk_mbytes(MB)] ??
mf.physical_name
FROM    sys.dm_io_virtual_file_stats(DB_ID('master')?? 1) AS vfs
JOIN sys.master_files AS mf ON vfs.database_id = mf.database_id
AND vfs.FILE_ID = mf.FILE_ID
ORDER BY avg_total_latency DESC

???????sys.dm_io_virtual_file_stats(null??null)??????????????????????????????????????????????????master??????I/O????????????????к??????????￡?

????2??sys.dm_io_cluster_shared_drives??sys.dm_io_cluster_valid_path_names
??????????????????????????????????????????????鵽???????????????δ??sys.dm_io_cluster_shared_drives??????????????sys.dm_io_cluster_valid_path_names???檔