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.

Network Performance Monitor 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. You can detect potential problems before they cause an application or service failure.

The SQL Server 2000 monitor is available in Network Performance Monitor Premium Edition. To update your license, visit the WhatsUp Customer Portal.

The SQL Server 2000 monitor requires the following credential:

  • Windows

Configure the following:

  • Name. Enter a unique name for the active monitor. This name displays in the Monitor Library.
  • Description. (Optional) Enter additional information about the monitor. This description displays next to the monitor name in the 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.
  • Use in rescan. (Optional) Select this option to have the monitor appear in the Active Monitor list on the Device Properties page. Network Performance Monitor adds the monitor type to the device during a rescan, which is started using the Rescan button on the Device Properties page, if the protocol or service is active on the device.