Requesting detailed application information

If you request information about specific tasks using the third sp_sysmon parameter (applmon) sp_sysmon output gives statistics specific to each application individually, in addition to summary information. You can choose to display the detailed application information in one of two ways:

For example, if 10 users are logged in with isql, and 5 users are logged in with an application called sales_reports, requesting “application and login” information prints 15 detail sections. Requesting “application only” information prints 2 detail sections, one summarizing the activity of all isql users, and the other summarizing the activity of the sales_reports users.

The appl_and_login can be used with all sections of sp_sysmon. This is an example of the syntax:

sp_sysmon “00:05:00”, @applmon=appl_and_login

See “Specifying the application detail parameter”.