The MS SQL Availability Database Details attribute group provides information about the availability databases that are hosted by the SQL Server instance. This attribute group is supported for SQL Server 2012 Enterprise Edition, or later.
Database IDThe ID of the availability database that is hosted by the SQL Server instance. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
Database NameThe name of the availability database that is hosted by the SQL Server instance. The following values are valid:
External value Internal value Description
Not Collected Not_collected The value cannot be collected.
Not Applicable Not_applicable The value is not supported.
Database StateIndicates the current state of the availability database. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
Chapter 4. Attributes reference 87
External value Internal value Description
No Data -3 No data is collected.
Online 1 The database is available for access.
Restoring 2 The database is currently unavailable
because of one of the following reasons:
v One or more files of the primary group are being restored.
v One or more secondary files are being restored offline.
Recovering 3 The database is currently unavailable and
is being recovered. If the database recovery is successful, the database state changes to Online. If the database recovery fails, the database state changes to Suspect.
Recovery Pending 4 The database is currently unavailable
because of one of the following reasons:
v Some files are missing.
v The database cannot start because of system resource limitations.
Suspect 5 The database is currently unavailable
because of the following reasons:
v The primary file group is damaged.
v Database cannot be recovered during the SQL Server startup.
Emergency 6 The database is currently in the single-user
mode, and is being repaired or restored.
The following actions are completed when the database is in the Emergency mode:
v The database is marked read-only.
v Logging is disabled.
v Access is limited to the members of the sysadmin fixed server role.
Offline 7 The database is not available for access.
Group Database IDThe ID of the availability group database that is hosted by the SQL Server instance.
The following values are valid:
External value Internal value Description
Not Collected Not_collected The value cannot be collected.
Not Applicable Not_applicable The value is not supported.
No Data nodata No data is collected.
Group IDThe ID of the availability group to which the availability database belongs. The following values are valid:
External value Internal value Description
Not Collected Not_collected The value cannot be collected.
Not Applicable Not_applicable The value is not supported.
No Data nodata No data is collected.
Group NameThe name of the availability group to which the availability database belongs. The following values are valid:
External value Internal value Description
Not Collected Not_collected The value cannot be collected.
Not Applicable Not_applicable The value is not supported.
Hub TimestampThe time when data is inserted at the hub.
LocalIndicates whether the availability replica is hosted by the local SQL Server instance. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected.
No 1 The replica is not hosted by the local
instance.
Yes 2 The replica is hosted by the local instance.
OriginnodeThe key for the table view in the format serverid:hostname:MSS.
Replica IDThe ID of the availability replica. The following values are valid:
External value Internal value Description
Not Collected Not_collected The value cannot be collected.
Not Applicable Not_applicable The value is not supported.
No Data nodata No data is collected.
RoleIndicates whether the availability database is a primary or a secondary database. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected.
Resolving 1 The system is trying to gather information
about the role of the database.
Primary 2 The database is the primary database.
Secondary 3 The database is the secondary database.
Invalid 4 The availability group that is associated
with the database is offline.
ServerThe name of the SQL Server.
Suspend ReasonThe reason for a database to enter the suspended state. The following values are valid:
Chapter 4. Attributes reference 89
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected. This enum is shown
if the database is not suspended.
Suspend From User 1 The reason for the database to be
suspended is Suspend From User.
Suspend From Partner 2 The reason for the database to be
suspended is Suspend From Partner.
Suspend From Redo 3 The reason for the database to be
suspended is Suspend From Redo.
Suspend From Apply 4 The reason for the database to be
suspended is Suspend From Apply.
Suspend From Capture 5 The reason for the database to be
suspended is Suspend From Capture.
Suspend From Restart 6 The reason for the database to be
suspended is Suspend From Restart.
Suspend From Undo 7 The reason for the database to be
suspended is Suspend From Undo.
Suspend From Revalidation 8 The reason for the database to be
suspended is Suspend From Revalidation.
Synchronization HealthIndicates the health of the availability database replica. The replica is healthy if the synchronized and the asynchorinzed replicas are in the Synchronized state. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected.
Not Healthy 1 The synchronization health of the database
replica that is hosted on the SQL Server instance is not healthy.
Partially Healthy 2 The synchronization health of the database
replica that is hosted on the SQL Server instance is partially healthy.
Healthy 3 The synchronization health of the database
replica that is hosted on the SQL Server instance is healthy.
Synchronization StateThe current synchronization state of the availability database replica. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected.
External value Internal value Description
Not Synchronizing 1 On a primary database, this value
indicates that the database is not ready to synchronize the transaction log with the secondary database.
On a secondary database, this value indicates that the database is not synchronizing because of one of the following reasons:
v The database has not started log synchronization.
v The database is being suspended.
v The database is going through the transition state during the startup.
v The database role is changing.
Synchronizing 2 On a primary replica, this value indicates
that the database is ready to accept a scan request from the secondary database.
On a secondary replica, this value indicates that an active data movement is in progress.
Synchronized 3 On a primary replica, this value indicates
that at least one secondary database is synchronized, and is available as a target for a failover without data loss.
On a secondary replica, this value indicates that all secondary databases are synchronized with the corresponding primary databases.
Reverting 4 Indicates that the availability database
replica is in the Reverting state.
Note: If the availability database replica is forced to shut down when the replica is in the Reverting state, you may not be able to start the replica again.
Initializing 5 Indicates that the availability database
replica is in the Initializing state.
Note: If the availability database replica is forced to shut down when the replica is in the Initializing state, you may not be able to start the replica again.
Synchronized CommitIndicates whether the transaction commit is synchronized with the database replica. The following values are valid:
External value Internal value Description
Not Collected -1 The value cannot be collected.
Not Applicable -2 The value is not supported.
No Data -3 No data is collected.
Not Synchronized 1 The transaction commit is not
synchronized with the database replica.
Synchronized 2 The transaction commit is synchronized
with the database replica.
Chapter 4. Attributes reference 91