If you request information about specific tasks using the third sp_sysmon parameter, sp_sysmon output gives statistics specific to each application individually in addition to summary information. You can choose to display detailed application information in one of two ways:
Application and login information (using the sp_sysmon parameter appl_and_login) – sp_sysmon prints a separate section for each login and the applications it is executing.
Application information only (using the sp_sysmon parameter, appl_only) – sp_sysmon prints a section for each application, which combines data for all of the logins that are executing it.
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 the sp_sysmon. An example of the syntax:
sp_sysmon “00:05:00”, @applmon=appl_and_login
See “Specifying the application detail parameter” for information on specifying the parameters for sp_sysmon.
