Specifying report sections for output

To print only a single section of the report, use one of the values listed in Table 8-1 for the second parameter.

**Table 8-1: sp_sysmon report sections**
Report section	Parameter
Application Management	appmgmt
Cache Wizard	cache wizard
Data Cache Management	dcache
Disk I/O Management	diskio
ESP Management	esp
Houskeeper Task Activity	housekeeper
Index Management	indexmgmt
Kernel Utilization	kernel
Lock Management	locks
Memory Management	memory
Metadata Cache Management	mdcache*
Monitor Access to Executing SQL	monaccess
Network I/O Management	netio
Parallel Query Management	parallel
Procedure Cache Management	pcache
Recovery Management	recovery
Task Management	taskmgmt
Transaction Management	xactmgmt
Transaction Profile	xactsum
Worker Process Management	wpm

* Most of the information available through sp_sysmon_mdcache can be obtained throu using sp_monitorconfig.