sys.dm_io_cluster_valid_path_names (Transact-SQL)


Updated: June 10, 2016

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

Returns information on all valid shared disks, including clustered shared volumes, for a SQL Server failover cluster instance. If the instance is not clustered, an empty rowset is returned.

Column nameData typeDescription
path_nameNvarchar(512)Volume mount point or drive path that can be used as a root directory for database and log files. Is not nullable.
cluster_owner_nodeNvarchar(64)Current owner of the drive. For cluster shared volumes (CSV), the owner is the node which is hosting the MetaData Server. Is not nullable.
is_cluster_shared_volumeBitReturns 1 if the drive on which this path is located is a cluster shared volume; otherwise, returns 0.

A SQL Server failover cluster instance (FCI) must use shared storage between all nodes of the FCI for data and log file storage. The disks listed in this view are those that are in the cluster resource group associated with the instance and are the only disks that can be used for data or log file storage.

System_CAPS_ICON_note.jpg Note

This view will replace sys.dm_io_cluster_shared_drives (Transact-SQL) in a future release.

The user must have VIEW SERVER STATE permission for the SQL Server instance.

The following example uses sys.dm_io_cluster_valid_path_names to determine the shared drives on a clustered server instance:

SELECT * FROM sys.dm_io_cluster_valid_path_names;  

sys.dm_os_cluster_nodes (Transact-SQL)
sys.dm_io_cluster_shared_drives (Transact-SQL)
Dynamic Management Views and Functions (Transact-SQL)

Community Additions