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.

  1. In the web interface, select Configure > Active Monitor Library, then click New. The Select Active Monitor Type dialog opens.
  2. Select SQL Server Monitor and click OK. The New SQL Server Monitor dialog opens.
    1. In the Name box, enter SQLUser.
    2. In the SQL Server Instance Name box, enter the name of your database.
    3. Make sure that Users 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.
    4. Click the Users parameter to select it, then click Configure. 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.
    5. When finished, click OK to add the SQLUser monitor to the Active Monitor Library.
  3. Add the SQLUser monitor to your SQL server device.
    1. In the device list, select the device that represents the SQL server. Right-click the device, then select Properties. Select Active Monitors.
    2. Click Add. 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.