| title | View Availability Group Properties (SQL Server) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/14/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | high-availability | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | 61243c87-bd62-4510-863f-2a8f347caf1f | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| manager | craigg |
This topic describes how to view the properties of an availability group for an AlwaysOn availability group by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql] in [!INCLUDEssCurrent].
To view and change the properties an availability group
-
In Object Explorer, connect to the server instance that hosts the primary replica, and expand the server tree.
-
Expand the AlwaysOn High Availability node and the Availability Groups node.
-
Right-click the availability group whose properties you want to view, and select the Properties command.
-
In the Availability Group Properties dialog box, use the General and Backup Preferences pages to view and, in some cases, change properties of the selected availability group. For more information, see Availability Group Properties and New Availability Group (General Page) and Availability Group Properties: New Availability Group (Backup Preferences Page).
Use the Permissions page to view the current logins, roles, and explicit permissions associated with the availability group. For more information, see Permissions or Securables Page.
To view the properties and state of an availability group
To query the properties and states of the availability groups for which the server instance hosts an availability replica, use the following views:
sys.availability_groups
Returns a row for each availability group for which the local instance of [!INCLUDEssNoVersion] hosts an availability replica. Each row contains a cached copy of the availability group metadata.
Column names: group_id, name, resource_id, resource_group_id, failure_condition_level, health_check_timeout, automated_backup_preference, automated_backup_preference_desc
sys.availability_groups_cluster
Returns a row for each availability group in the WSFC cluster. Each row contains the availability group metadata from the Windows Server Failover Clustering (WSFC) cluster.
Column names: group_id, name, resource_id, resource_group_id, failure_condition_level, health_check_timeout, automated_backup_preference, automated_backup_preference_desc
sys.dm_hadr_availability_group_states
Returns a row for each availability group that possesses an availability replica on the local instance of [!INCLUDEssNoVersion]. Each row displays the states that define the health of a given availability group.
Column names: group_id, primary_replica, primary_recovery_health, primary_recovery_health_desc, secondary_recovery_health, secondary_recovery_health_desc, synchronization_health, synchronization_health_desc
To view information about availability groups
To configure an existing availability group
-
Add a Secondary Replica to an Availability Group (SQL Server)
-
Remove a Secondary Replica from an Availability Group (SQL Server)
-
Remove a Secondary Database from an Availability Group (SQL Server)
-
Create or Configure an Availability Group Listener (SQL Server)
-
Remove a Primary Database from an Availability Group (SQL Server)
To manually fail over an availability group
-
Perform a Planned Manual Failover of an Availability Group (SQL Server)
-
Perform a Forced Manual Failover of an Availability Group (SQL Server)
Overview of AlwaysOn Availability Groups (SQL Server) Monitor Availability Groups (Transact-SQL) AlwaysOn Policies for Operational Issues with AlwaysOn Availability Groups (SQL Server)