Redigera

Dela via


sys.dm_hadr_cluster_networks (Transact-SQL)

Applies to: SQL Server

Returns a row for every WSFC cluster member that is participating in an availability group's subnet configuration. You can use this dynamic management view to validate the network virtual IP that is configured for each availability replica.

Primary key: member_name + network_subnet_ip + network_subnet_prefix_length

Tip

Beginning in SQL Server 2014 (12.x), this dynamic management view supports Always On failover cluster instances (FCIs) in addition to availability groups (AGs).

Column name Data type Description
member_name nvarchar(128) A computer name of a node in the WSFC cluster.
network_subnet_ip nvarchar(48) Network IP address of the subnet to which the computer belongs. This can be an IPv4 or IPv6 address.
network_subnet_ipv4_mask nvarchar(45) Network subnet mask that specifies the subnet to which the IP address belongs. network_subnet_ipv4_mask to specify the DHCP <network_subnet_option> options in a WITH DHCP clause of the CREATE AVAILABILITY GROUP or ALTER AVAILABILITY GROUPTransact-SQL statement.

NULL = IPv6 subnet.
network_subnet_prefix_length int Network IP prefix length that specifies the subnet to which the computer belongs.
is_public bit Whether the network is private or public on the WSFC cluster, one of:

0 = Private
1 = Public
is_ipv4 bit Type of the subnet, one of:

1 = IPv4
0 = IPv6

Remarks

In a Windows Server Failover Cluster (WSFC), the cluster columns display the Windows cluster details. In cases where there's no Windows cluster, such as read-scale availability groups, or availability groups on Linux, columns related to the cluster might display data about an internal default cluster. These columns are for internal use only and can be disregarded.

Permissions

For SQL Server 2019 (15.x) and previous versions, requires VIEW SERVER STATE permission on the server.

For SQL Server 2022 (16.x) and later versions, requires VIEW SERVER PERFORMANCE STATE permission on the server.