Adding and editing a SQL Server 2000 monitor

The SQL Server 2000 monitor provides real-time information about the state and health of Microsoft SQL Server applications on your network. This monitor supports monitoring of Microsoft SQL Server 2000, and MSDE 2000 or later versions, which can be installed on any machine in your network.

Note: Although the SQL Server monitor is designed for Microsoft SQL Server 2000, some of the objects may also work with SQL Server 2005 or later.

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 2000 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.

Note: This feature is available with WhatsUp Gold Premium Edition only. To update your license, visit the WhatsUp Customer Portal.

To add a new SQL Server 2000 active monitor:

1. From the WhatsUp Gold web interface, go to Admin > Monitors. The Monitor Library dialog appears.
2. Click the Active tab. The Active Monitor list appears.
3. Click New. The Select Active Monitor Type dialog appears.
4. Select SQL Server 2000 Monitor, then click OK. The New SQL Server 2000 Monitor dialog appears.
5. Enter or select the appropriate information:
   • Name. Enter a unique name for the active monitor. This name displays in the Active Monitor Library.
   • Description. (Optional) Enter additional information about the monitor. This description displays next to the monitor in the Active Monitor Library.
   • SQL Server Instance Name. Enter the name of the database you want to monitor.
   • Thresholds to monitor. For more information about specific thresholds, see SQL Server Parameters.
   • Services to monitor. For more information about specific services, see SQL Server Services.
6. (Optional) Select Use in rescan to add the monitor to the Active Monitors list. From that list, you can select to scan for that service on all applications found during discovery.
7. Click OK to save changes.
8. After configuring an active monitor in the Active Monitor Library, add the monitor to devices.

To edit an existing SQL Server 2000 active monitor:

1. From the WhatsUp Gold web interface, go to Admin > Monitors. The Monitor Library dialog appears.
2. Click the Active tab. The Active Monitor list appears.
3. Select the monitor you would like to edit, then click Edit. The Edit SQL Server 2000 Monitor dialog appears.
4. Enter or select the appropriate information:
   • Name. Enter a unique name for the active monitor. This name displays in the Active Monitor Library.
   • Description. (Optional) Enter additional information about the monitor. This description displays next to the monitor in the Active Monitor Library.
   • SQL Server Instance Name. Enter the name of the database you want to monitor.
   • Thresholds to monitor. For more information about specific thresholds, see SQL Server Parameters.
   • Services to monitor. For more information about specific services, see SQL Server Services.
5. (Optional) Select Use in rescan to add the monitor to the Active Monitors list. From that list, you can select to scan for that service on all applications found during discovery.
6. Click OK to save changes.

See Also Using Premium active monitors Adding and editing an APC UPS Monitor Monitoring mail servers Monitoring Microsoft Exchange 2003 servers Monitoring a Microsoft Exchange Server Adding and editing a Fan Monitor 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 PowerShell active monitor Adding and editing a Printer Monitor Adding and editing a Process Monitor Adding and editing a SQL Query active monitor Adding and editing a Temperature Monitor Adding and editing a VoIP Monitor Adding and editing a WMI Formatted active monitor Adding and Editing a WMI Monitor Assigning active monitors Removing and deleting active monitors About critical active monitors Group and Device active monitor reports