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.
: 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.
: 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:
- From the WhatsUp Gold web interface, go to . The Monitor Library dialog appears.
- Click the tab. The Active Monitor list appears.
- Click . The Select Active Monitor Type dialog appears.
- Select , then click . The New SQL Server 2000 Monitor dialog appears.
- Enter or select the appropriate information:
- . Enter a unique name for the active monitor. This name displays in the Active Monitor Library.
- . (Optional) Enter additional information about the monitor. This description displays next to the monitor in the Active Monitor Library.
- Enter the name of the database you want to monitor.
- . For more information about specific thresholds, see SQL Server Parameters.
- . For more information about specific services, see SQL Server Services.
- (Optional) Select 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.
- Click to save changes.
- After configuring an active monitor in the Active Monitor Library, add the monitor to devices.
To edit an existing SQL Server 2000 active monitor:
- From the WhatsUp Gold web interface, go to . The Monitor Library dialog appears.
- Click the tab. The Active Monitor list appears.
- Select the monitor you would like to edit, then click . The Edit SQL Server 2000 Monitor dialog appears.
- Enter or select the appropriate information:
- . Enter a unique name for the active monitor. This name displays in the Active Monitor Library.
- . (Optional) Enter additional information about the monitor. This description displays next to the monitor in the Active Monitor Library.
- Enter the name of the database you want to monitor.
- . For more information about specific thresholds, see SQL Server Parameters.
- . For more information about specific services, see SQL Server Services.
- (Optional) Select 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.
- Click to save changes.