La requête suivante retourne l’activité disque enregistrée par SQL Server depuis le démarrage de l’instance, par fichier de base de données.
SELECT
DB_NAME(mf.database_id) as db,
mf.name,
LEFT(mf.physical_name, 2) as disque,
fs.num_of_reads, fs.num_of_bytes_read,
fs.num_of_writes, fs.num_of_bytes_written,
fs.io_stall, fs.io_stall_read_ms, fs.io_stall_write_ms
FROM sys.dm_io_virtual_file_stats(null,null) AS fs
INNER JOIN sys.master_files AS mf
ON fs.database_id = mf.database_id
AND fs.[file_id] = mf.[file_id]
DB_NAME(mf.database_id) as db,
mf.name,
LEFT(mf.physical_name, 2) as disque,
fs.num_of_reads, fs.num_of_bytes_read,
fs.num_of_writes, fs.num_of_bytes_written,
fs.io_stall, fs.io_stall_read_ms, fs.io_stall_write_ms
FROM sys.dm_io_virtual_file_stats(null,null) AS fs
INNER JOIN sys.master_files AS mf
ON fs.database_id = mf.database_id
AND fs.[file_id] = mf.[file_id]