Backup SQL Test

This test monitors the availability and response time from clients by the Backup Microsoft SQL database server in a cluster.

Target of the test : A Backup SQL server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for the Backup SQL server being monitored.

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed.


The IP address of the host for which this test is to be configured.


The port at which the specified Host listens.


A database user name.


The password associated with the above user name (can be ‘NULL’). Here, ‘NULL’ means that the user does not have any password.

Confirm Password

Confirm the Password (if any) by retyping it here.


The name of the database to connect to. The default is “master”.


The select query to execute. The default is  “select * from master.dbo.spt_monitor”.


The IP/hostname of the primary Microsoft SQL server in a cluster.


The port number at which the primary Microsoft SQL server listens.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Service availability

Indicates the availability of the server


The availability is 100% when the server is responding to a request and 0% when it is not. Availability problems may be caused by a misconfiguration/malfunctioning of the database server, or if the server has not been started.

Response time

Indicates the time taken by the database to respond to a user query


A sudden increase in response time is indicative of a bottleneck at the database server.