[SQL Server] Afficher l'état des I/O des fichiers de la base de données

  • Imprimer

SELECT db_name(database_id) as database__name,file_name(file_id) file__name,
io_stall/1000.0 AS avg_io_latency_ms,
num_of_reads,
num_of_writes,
io_stall_read_ms/num_of_reads AS avg_read_latency_ms,
io_stall_write_ms/num_of_writes AS avg_write_latency_ms
FROM sys.dm_io_virtual_file_stats(DB_ID(), NULL);