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.
