Specifying report sections for output

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

Table 39-1: sp_sysmon report sections

Report section

Parameter

Application Management

appmgmt

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.