Specifying the application detail parameter

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. Can be used with all sections.

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.