Specifying the application detail parameter

If you specify the applmon 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 specify appmgmt for the section parameter. If you specify the application detail parameter and request any other section of the report, the application detail parameter is ignored.

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.