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 74 n/a
Engine 0 n/a n/a 20 n/a
Engine 1 n/a n/a 21 n/a
Engine 2 n/a n/a 18 n/a
Engine 3 n/a n/a 23 n/a
Engine 4 n/a n/a 18 n/a
Engine 5 n/a n/a 20 n/a
Engine 6 n/a n/a 21 n/a
Engine 7 n/a n/a 17 n/a
Engine 8 n/a n/a 20 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 202.8 1.7 12261 n/a
Completed Disk I/O’s
Engine 0 25.0 0.2 1512 12.4 %
Engine 1 21.1 0.2 1274 10.5 %
Engine 2 18.4 0.2 1112 9.1 %
Engine 3 23.8 0.2 1440 11.8 %
Engine 4 22.7 0.2 1373 11.3 %
Engine 5 22.9 0.2 1387 11.4 %
Engine 6 24.4 0.2 1477 12.1 %
Engine 7 22.0 0.2 1332 10.9 %
Engine 8 21.2 0.2 1281 10.5 %
------------------------- --------- --------- ------- ----------
Total Completed I/Os 201.6 1.7 12188
d_master
master per sec per xact count % of total
------------------------- --------- --------- ------- ----------
Reads
APF 56.6 0.5 3423 46.9 %
Non-APF
Writes 64.2 0.5 3879 53.1 %
------------------------- --------- --------- ------- ----------
Total I/Os 120.8 1.0 7302 60.0 %
Device Semaphore Granted 116.7 1.0 7056 94.8 %
Device Semaphore Waited 6.4 0.1 388 5.2 %
