Visualizar lecturas y escrituras del Servidor SQL
Podemos visualizar las lecturas y escrituras, y incluso el tiempo que tardan del servidor SQL Server
SELECT @@TOTAL_READ [Total Reads]
, @@TOTAL_WRITE as [Total Writes]
, CAST(@@IO_BUSY as FLOAT) * @@TIMETICKS / 1000000.0 as [IO Sec]
GO
Esta sentencia devuelve:
Total Reads Total Writes IO Sec
----------- ------------ -----------
85336 322109 25.375