sys.dm_hadr_cluster_networks (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

System_CAPS_ICON_tip.jpg Tip

Beginning in SQL Server 2014, this dynamic management view supports Always On Failover Cluster Instances in addition to Always On Availability Groups.

Column nameData typeDescription
member_namenvarchar(128)A computer name of a node in the WSFC cluster.
network_subnet_ipnvarchar(48)Network IP address of the subnet to which the computer belongs. This can be an IPv4 or IPv6 address.
network_subnet_ipv4_masknvarchar(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_lengthintNetwork IP prefix length that specifies the subnet to which the computer belongs.
is_publicbitWhether the network is private or public on the WSFC cluster, one of:

0 = Private

1 = Public
is_ipv4bitType of the subnet, one of:

1 = IPv4

0 = IPv6


Requires VIEW SERVER STATE permission on the server.

Failover Clustering and Always On Availability Groups (SQL Server)
Monitor Availability Groups (Transact-SQL)
sys.dm_os_cluster_nodes (Transact-SQL)
Querying the SQL Server System Catalog FAQ
Catalog Views (Transact-SQL)

Community Additions