SQL Server

The SQL Server 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.

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

Provide a unique name and description for the monitor, then configure the following:

SQL Server Instance Name. Enter the name of the database to monitor.
Thresholds to monitor. Enable monitoring for specific parameters by selecting the respective checkboxes.
Configure. Click to specify values for the selected parameter.
Services to monitor. Enable monitoring for specific services by selecting the respective checkboxes.
Use in rescan. Enable this option to have the monitor appear in Device Properties. If enabled, clicking Rescan Device from the device management actions menu within the Device Properties interface adds the monitor to the selected device if the applicable protocol or service is active on that device.

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