The following sample shows sp_sysmon output for the “Index Management” categories.
============================================================================= Index Management ---------------- Nonclustered Maintenance per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Ins/Upd Requiring Maint 0.0 0.0 0 n/a # of NC Ndx Maint 0.0 0.0 0 n/a Deletes Requiring Maint 0.0 0.0 0 n/a # of NC Ndx Maint 0.0 0.0 0 n/a RID Upd from Clust Split 0.0 0.0 0 n/a # of NC Ndx Maint 0.0 0.0 0 n/a Upd/Del DOL Req Maint 0.0 0.0 0 n/a # of DOL Ndx Maint 0.0 0.0 0 n/a Page Splits 0.0 0.0 0 n/a Page Shrinks 0.0 0.0 0 n/a Index Scans per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Ascending Scans 0.0 0.5 2 100.0 % DOL Ascending Scans 0.0 0.0 0 0.0 % Descending Scans 0.0 0.0 0 0.0 % DOL Descending Scans 0.0 0.0 0 0.0 % ------------ ------------ ----------
