sys.dm_hadr_availability_replica_cluster_nodes (Transact-SQL)sys.dm_hadr_availability_replica_cluster_nodes (Transact-SQL)

適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions) 適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions)

針對 Windows Server 容錯移轉叢集 (WSFC) 叢集中 AlwaysOn 可用性群組的每一個可用性複本 (不論聯結狀態為何),各傳回一個資料列。Returns a row for every availability replica (regardless of join state) of the Always On availability groups in the Windows Server Failover Clustering (WSFC) cluster.

資料行名稱Column name 資料類型Data type 描述Description
group_namegroup_name nvarchar(256)nvarchar(256) 可用性群組的名稱。Name of the availability group.
replica_server_namereplica_server_name nvarchar(256)nvarchar(256) 裝載此複本的 SQL ServerSQL Server 執行個體名稱。Name of the instance of SQL ServerSQL Server hosting the replica.
node_namenode_name nvarchar(256)nvarchar(256) 叢集節點的名稱。Name of the cluster node.

安全性Security

權限Permissions

需要伺服器的 VIEW SERVER STATE 權限。Requires VIEW SERVER STATE permission on the server.

另請參閱See Also

監視可用性群組 (Transact-sql) Monitor Availability Groups (Transact-SQL)
AlwaysOn 可用性群組概觀 (SQL Server)Overview of Always On Availability Groups (SQL Server)