Adding and editing a SQL Server Monitor

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 installed on any machine in your network.

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

WhatsUp Gold can monitor and report the status of the standard services associated with TCP/IP servers, such as SMTP, POP3, and IMAP, FTP, HTTP. If any of these services fail, users are unable to get mail, transfer files, or use the web. It is a good practice to set up monitoring on these services so you are the first to know if they fail. The SQL Server Monitor extends monitoring to parameters reported by Microsoft SQL Server (and Microsoft MSDE), allowing you to get an early warning of a degradation in performance. For example, you can monitor system parameters on your SQL Server database server to see if performance is within an expected range, and if not, you can intervene before the SQL Server fails. In other words, you can detect a looming problem before it causes an application or service failure.

To configure an instance of the SQL Server Monitor:

Note: This feature is only available in WhatsUp Gold Premium Edition. To update your license, visit the MyIpswitch portal.

1. Click the Admin tab, then click Monitor Library. The Monitor Library dialog appears.
2. Click the Active tab. The Active Monitor list 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.

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

      

   3. In the Name box, type 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, type any text information to further describe the monitor.
   5. In the SQL Server Instance Name box, type 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.
4. Add the monitor to your SQL Server device.
   1. In your device list, find the device that represents the SQL Server.
   2. Right-click the device, then select Properties.
   3. Select Active Monitors.
   4. Click Add. The Active Monitor wizard appears.
   5. Select the monitor from the list, and continue with the wizard to configure any actions for the monitor.

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

   Note: If you select Use in rescan, 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.

5. Click OK to save changes.

After configuring an active monitor in the Active Monitor Library, add the monitor to devices.

See Also Using Premium Active Monitors Adding and editing an APC UPS Monitor Monitoring mail servers Monitoring a Microsoft Exchange Server Getting Started with Exchange Monitors Adding and Editing an Exchange Monitor Example: Exchange Server monitor Monitoring Microsoft Exchange 2003 Servers Adding and editing a File Properties Monitor Adding and editing a Folder Monitor Adding and editing an FTP Monitor Adding and editing an HTTP Content Monitor Adding and editing a Network Statistics Monitor Adding and editing a Power Supply Monitor Adding and editing a Printer Monitor Adding and editing a Process Monitor Adding and editing a SQL Query Monitor Adding and Editing a WMI Monitor Adding and editing a VoIP Monitor Adding and editing an Active Script Active Monitor Assigning active monitors Removing and deleting active monitors About critical active monitors Group and Device active monitor reports