Example: SQL Server Monitor
To monitor user activity on a SQL Server, you
can create a monitor called SQLUser
,
then select Users as the only parameter to monitor.
- In the web interface, select , then
click . The Select Active
Monitor Type dialog opens.
- Select SQL Server Monitor and click
. The New SQL Server Monitor
dialog opens.
- In the box, enter
SQLUser
.
- In the box, enter the name of your
database.
- Make sure that is the only parameter that has a check
in the box to the left of it. You will need to clear the selections
for the other parameters and also for the processes.
- Click the parameter to select it, then click
. The Users Threshold
dialog opens. You should have in mind how many users or connections
you want to consider as a threshold, and enter those values in the
appropriate boxes on the dialog.
- When finished, click to add the SQLUser monitor to the Active
Monitor Library.
- Add the SQLUser monitor to your SQL server
device.
- In the device list, select the device that
represents the SQL server. Right-click the device, then select
. Select Active
Monitors.
- Click . The Active Monitor wizard opens.
Select the SQLUser monitor and continue
with the wizard to add to configure actions for the monitor.
For more information on setting up an
action, see Configuring an Action.
After you complete the wizard, the monitor
immediately begins to monitor the SQL Server application.