Edit

sys.dm_io_cluster_valid_path_names (Transact-SQL)

  • Article

Applies to: SQL Server

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 name Data type Description
path_name Nvarchar(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_node Nvarchar(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_volume Bit Returns 1 if the drive on which this path is located is a cluster shared volume; otherwise, returns 0.

Remarks

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.

Note

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

Permissions

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

Permissions for SQL Server 2022 and later

Requires VIEW SERVER PERFORMANCE STATE permission on the server.

Examples

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;

See also

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