SQL Query (Active)

The SQL Query monitor uses WMI or ADO authentication to determine if specific conditions exist in a Microsoft SQL, MySQL, or ORACLE database by querying the database. If the configured conditions are present, the monitor is Up. If changes made to the database since the last query cause data to no longer fall within the defined criteria, the monitor is Down.

Important: To monitor a MySQL database, download and install the MySQL .NET Connector on the WhatsUp Gold machine. Please note, only MySQL version 5.2.5 is supported due to potential compatibility issues. MySQL .NET Connector version 5.2.5 can be downloaded directly from the WhatsUp Gold website (http://www.whatsupgold.com/MySQL525Connector).

Note: When connecting to a remote SQL instance, WhatsUp Gold only supports the TCP/IP network library.

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

• Server Type. Select Microsoft SQL Server, MySQL, or ORACLE as the database server type. Please note, MySQL database is supported and listed as a server type option only if the MySQL 5.2.5 Connector is installed.
• Connection Timeout. Enter the amount of time WhatsUp Gold waits for the server to respond before terminating the connection and returning the timeout error. The minimum allowed value is 1 second whereas maximum allowed value is 120. Please note, this setting only applies to polling whereas the query builder assumes a default of 15 seconds for the connection timeout.
• Server Address. Enter the server address in the applicable format:
  • ServerName\Instance format for Microsoft SQL Server. Example: WUGServer\SQLEXPRESS
  • ServerName for MySQL. Example: WUGServer
  • ServerName/ServiceName for Oracle. Example: WUGServer/Oracle.
• Port. Enter the database server port number.
• SQL Query to Run. Enter the query to run against the specified database to check for certain database conditions. .

Click Build to launch the SQL Query Builder for assistance with developing proper query syntax. Only SELECT queries are allowed.

Important: The SQL query you enter must return a single numeric value. Specifically, a single record that has just one column. If the query returns more than one record, the monitor fails to store the data. If the query returns a single record but there are multiple columns in the record returned, then the monitor will pick the first column as the value to store and this first column has to be numeric, otherwise the monitor will fail to store the data.

Click Verify to test if the entered database query is valid.

Number of rows returned is. Select this option to determine the success or failure of the monitor scan based on rows returned by the SQL query. All database rows must match the criteria settings for the monitor to be considered Up.

Content of each retrieved row matches the following criteria. Select this option to determine the success or failure of the monitor scan based on criteria which each database row must match. If multiple threshold criteria are used, all thresholds must match the criteria in each row for the monitor to be considered Up.

Click Add, Edit, and Delete as needed to create, modify, and remove database column values and conditions, respectively.

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 Server 2000 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