Monitoring Microsoft SQL Server

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.

Note: Microsoft SQL Monitor is available as part of WhatsUp Gold Premium Edition.

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.

Why use it?

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, your users will be unable to get mail, transfer files, or use the web.  It is a good idea to set up monitoring on these services so that 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.

Related Topics Getting Started Using SQL Server Monitor Monitor/Service Properties for SQL Server