Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.dm_hadr_cluster_networks (Transact-SQL)

SQL Server 2012

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

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 GROUP Transact-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

Permissions

Requires VIEW SERVER STATE permission on the server.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.