If a user complaints of problems while accessing a database, the knowledge of the current state of that database and the mode using which users are allowed to access the database will enable administrators to promptly diagnose the reason for such an occurrence. This test auto-discovers all the database instances on the target Microsoft SQL Azure database server and reports the current state of each database instance and the user access mode thereby enabling administrators to easily troubleshoot issues related to database access.
Target of the test : A Microsoft SQL Azure database server
Agent deploying the test : An external/remote agent
Outputs of the test : One set of results for each database instance of the target Microsoft SQL Azure database server being monitored.
|
Measurement | Description | Measurement Unit | Interpretation | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Status |
Indicates the current state of this database instance. |
|
The states that can be reported by this measure, the numeric value that corresponds to each state, and a brief description of the state are provided below:
The detailed diagnosis of this measure reports the user access mode of the database, the database recovery model, and the log re-use wait state of the database. Note: By default, this measure reports the States listed in the table above to indicate the current status of the database instance. The graph of this measure however, represents the status of the database using the numeric equivalents only i.e., 0 to 6 only. |
||||||||||||||||||||||||
Is in standby? |
Indicates whether/not this database instance is in standby mode. |
|
The values reported by this measure and its numeric equivalents are mentioned in the table below:
Note: By default, this measure reports the Measure Values listed in the table above to indicate whether/not the database instance is in standby mode. The graph of this measure however, is represented using the numeric equivalents only i.e., 0 or 1. |
||||||||||||||||||||||||
Is read only? |
Indicates whether/not this database instance is in READ_ONLY mode. |
|
The values reported by this measure and its numeric equivalents are mentioned in the table below:
Note: By default, this measure reports the Measure Values listed in the table above to indicate whether/not the database instance is in READ_ONLY mode. The graph of this measure however, is represented using the numeric equivalents only i.e., 0 or 1. |
||||||||||||||||||||||||
User access mode |
Indicates the user access mode to this database instance. |
|
The states that can be reported by this measure, the numeric value that corresponds to each state, and a brief description of the state are provided below:
Note: By default, this measure reports the Measure Values listed in the table above to indicate the user access mode to this database instance. The graph of this measure however, represents the status of the database using the numeric equivalents only i.e., 1 to 3 only. |