If you specify the third parameter to sp_sysmon, the report includes detailed information by application or by application and login name. This parameter is valid only when you print the entire report or when you request the “Application Management” section by specifying appmgmt as the section. It is ignored if you specify it and request any other section of the report.
The third parameter must be one of the following:
Parameter |
Information reported |
|---|---|
appl_only |
CPU, I/O, priority changes, and resource limit violations by application name. |
appl_and_login |
CPU, I/O, priority changes, and resource limit violations by application name and login name. |
no_appl |
Skips the application and login section of the report. This is the default. |
This example runs sp_sysmon for 5 minutes and prints the “Application Management” section, including the application and login detail report:
sp_sysmon "00:05:00", appmgmt, appl_and_login
See “Per application or per application and login” for sample output.
