Updated: June 10, 2016
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.|
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.
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;