The following sample shows sp_sysmon output for the “Disk I/O Management” section.
============================================================================= Disk I/O Management ------------------- Max Outstanding I/Os per sec per xact count % of total ----------------------- ------------ ------------ ---------- ---------- Server n/a n/a 2 n/a Engine 0 n/a n/a 2 n/a I/Os Delayed by Disk I/O Structures n/a n/a 0 n/a Server Config Limit n/a n/a 0 n/a Engine Config Limit n/a n/a 0 n/a Operating System Limit n/a n/a 0 n/a Total Requested Disk I/Os 0.0 0.5 2 Completed Disk I/O's Engine 0 0.0 0.5 2 100.0 % ------------------------- ------------ ------------ ---------- Total Completed I/Os 0.0 0.5 2 Device Activity Detail ---------------------- Device: /work/Devices/coffee.dat master per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.0 0.0 0 0.0 % Non-APF 0.0 0.0 0 0.0 % Writes 0.0 0.5 2 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.5 2 100.0 % ----------------------------------------------------------------------------- Device: /work/Devices/pubs2dat.dat pubs2dat per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.0 0 n/a ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.0 0 0.0 % -----------------------------------------------------------------------------
