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.
| Parameter | Description |
|---|---|
|
Test Period |
How often should the test be executed. |
|
Host |
The IP address of the host for which this test is to be configured. |
|
Port |
The port at which the specified Host listens. |
|
User |
A database user name. |
|
Password |
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. |
|
Database |
The name of the database to connect to. The default is “master”. |
|
Query |
The select query to execute. The default is “select * from master.dbo.spt_monitor”. |
|
ClusterName |
The IP/hostname of the primary Microsoft SQL server in a cluster. |
|
ClusterPort |
The port number at which the primary Microsoft SQL server listens. |
| Measurement | Description | Measurement Unit | Interpretation |
|---|---|---|---|
|
Service availability |
Indicates the availability of the server |
Percent |
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 |
Seconds |
A sudden increase in response time is indicative of a bottleneck at the database server. |
