SQL Server 2000

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.

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

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

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

See Also

Active Monitors

Active Script (Active)

APC UPS (Active)

Cloud Resource Monitor

Degraded Array

DNS

Email

Exchange 2003

Exchange

Fan

File Content

File Properties

Folder

FTP

HTTP Content

JMX (Active)

Network Statistics

NT Service

Ping Interarrival Jitter

Ping

Power Supply

PowerShell

Printer

Process

SMI-S

SNMP Extended

SNMP (Active)

SQL Query (Active)

SSH (Active)

SSL Certificate

TCPIP

Telnet

Temperature

VoIP

WAP Radio

WMI Formatted

WMI

Set Polling Properties

Apply Action to Monitor

Using Action Policies

Implicit Action Policy