Previously, sp_monitor event displayed all tasks (including system tasks), when called with no options. In versions 15.0.2 and above, the event option provides three possibilities:
When no option is provided, only user tasks are displayed.
When you specify sp_monitor, event, "-1", wait information about all tasks, both user and system, is displayed.
When you specify sp_monitor, event, "spid", wait information pertaining to only the specified server process ID is displayed.
The help option in sp_monitor also reports extensive information on using this procedure for deadlock analysis:
sp_monitor 'help', 'deadlock'
The help option also provides command-specific examples. For complete documentation of the help option see the Reference Manual.
