Skip to Content

Monitoring specific users and processes manually

By default, PATROL for Microsoft SQL Server does not automatically monitor individual users or processes that are not blocking other processes or that are idle. You can, however, manually set up individual users or processes to monitor.

Viewing a list of process IDs

You can review a list of all users and their process IDs that are currently on the SQL Server by using the KM Commands > KM Admin > User Monitoring Admin > Monitor Specific User > Lookup Process ID's from the Server application pop-up menu.

Warning

Note

You may want to review this list before you select individual users or processes to monitor.

Monitoring specific users by login name or by process ID

When you select a user to monitor, you can choose whether to monitor each user process individually or all processes together as an aggregate. If you choose to monitor each process individually, PATROL creates a Users application icon for each process. If you choose to monitor all processes as an aggregate, PATROL creates one Users application icon that represents the user.

You can select a user to monitor by login name by using the KM Commands > KM Admin > User Monitoring Admin > Monitor Specific User > By Login Name menu command from the Server application pop-up menu.

You can select a user process to monitor by process ID by using the KM Commands > KM Admin > User Monitoring Admin > Monitor Specific User > By Process ID (spid) menu command in the Server pop-up menu.

Stopping the monitoring of a user

You can stop monitoring a user or a process that you manually selected for monitoring by using the Stop Monitoring menu command in the Users application pop-up menu.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC PATROL for Microsoft SQL Server 9.5