Specifying report sections for output

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

Table 1-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

Housekeeper 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

RepAgent

repagent

Task Management

taskmgmt

Transaction Management

xactmgmt

Transaction Profile

xactsum

Worker Process Management

wpm

You can also obtain most of the information available through sp_sysmon mdcache report using sp_monitorconfig. See the Reference Manual: Procedures.