Configuring a SQL Server Monitor

The SQL Server Monitor lets you monitor Microsoft® SQL Server. The SQL Server Monitor provides real-time information about the state and health of Microsoft SQL Server applications on your network.

The SQL Server Monitor supports monitoring of Microsoft SQL Server 2000 or later versions, and MSDE 2000 or later versions, which can be on any machine in your network.

To create custom parameters to monitor, the SQL Server host must be WMI-enabled.

To configure an instance of the SQL Server Monitor:

Important: You must activate WhatsUp Gold Premium Edition before configuring a SQL Server Monitor.

1. Open to the Active Monitor Library:
   • From the web interface, click GO. The GO menu appears.
   • If the WhatsUp section is not visible, click WhatsUp. The WhatsUp section of the GO menu appears.
   • Select Configure > Active Monitor Library.

     - or -

   • From the main menu bar of the console, select Configure > Active Monitor Library. The Active Monitor Library appears.

   Tip: The Active Monitor Library is the starting point for creating any Active Monitor in WhatsUp Gold. This dialog shows all of the Active Monitors in your database.

2. Add a SQL monitor:
   1. Click New. The Select Active Monitor Type dialog appears.
   2. Select SQL Server Monitor and click OK. The New SQL Server Monitor dialog appears.

   3. In the Name box, enter the name you want to use to identify this instance of the SQL Server monitor. For example, if you are configuring a monitor to check disk space, you might enter SQLServerDisk.
   4. In the Description box, enter any text information to further describe the monitor.
   5. In the SQL Server Instance Name box, enter the name of the database you want to monitor.
   6. Select the thresholds to add to the monitor. For more information about specific thresholds, see SQL Server Parameters.
   7. Select the services to add to the monitor. For more information about specific services, see SQL Server Services.
   8. Click OK to save the monitor in the Active Monitor Library.
3. Add the monitor to your SQL Server device.
   1. In your device list, find the device that represents the SQL Server. Right-click the device, then select Properties. Select Active Monitors.
   2. Click Add. The Active Monitor wizard appears.

      Select the monitor, and continue with the wizard to configure any actions for the monitor.

      For more information on setting up an action, see Configuring an action.

   If you select Use in discovery, WhatsUp Gold adds the monitor to the Active Monitors list. From that list, you can select to scan for that service on all applications found during discovery.

See Also Monitoring Microsoft SQL Server How to get started using SQL Server Monitor Example: SQL Server Monitor