Ali je bila ta stran uporabna?
Vaše povratne informacije o tej vsebini so pomembne. Sporočite nam svoje mnenje.
Dodatne povratne informacije?
Preostali znaki: 1500
Izvozi (0) Natisni
Razširi vse
EN
Ta vsebina ni na voljo v vašem jeziku, vendar pa je tukaj angleška različica.

sys.dm_hadr_name_id_map (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Shows the mapping of AlwaysOn availability groups that the current instance of SQL Server has joined to three unique IDs: an availability group ID, a WSFC resource ID, and a WSFC Group ID. The purpose of this mapping is to handle the scenario in which the WSFC resource/group is renamed.

Applies to: SQL Server (SQL Server 2012 through current version).

Column name

Data type

Description

ag_name

nvarchar(256)

Name of the availability group. This is a user-specified name that must be unique within the Windows Server Failover Cluster (WSFC) cluster.

ag_id

uniqueidentifier

Unique identifier (GUID) of the availability group.

ag_resource_id

nvarchar(256)

Unique ID of the availability group as a resource in the WSFC cluster.

ag_group_id

nvarchar(256)

Unique WSFC Group ID of the availability group.

Requires VIEW SERVER STATE permission on the server.

Vsebina skupnosti

Dodaj
Pokaži:
© 2015 Microsoft