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:

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)

BGP Peer Status

Cloud Resource Monitor

DNS

Email

Exchange 2003

Exchange

Fan

File Content

File Properties

Folder

FTP

HTTP Content

JMX (Active)

Meraki Device Status Active Monitor

Network Statistics

Ping

Ping Interarrival Jitter

Power Supply

PowerShell

Printer

Process

REST API (Active)

Service

SMI-S

SNMP Extended

SNMP (Active)

SQL Query (Active)

SSH (Active)

SSL Certificate

Storage Controller Health monitor

Storage File System

Storage Disk Drives

Storage LUN

Storage Pool

TCPIP

Telnet

Temperature

VoIP

WAP Radio

WMI Formatted

WMI

Set Polling Properties

Apply Action to Monitor

Using Action Policies

Implicit Action Policy