Export (0) Print
Expand All

sys.dm_io_cluster_valid_path_names (Transact-SQL)

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.

Applies to: SQL Server (SQL Server 2014 through current version).

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.

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 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;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft