| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_io_cluster_valid_path_names (Transact-SQL) |
sys.dm_io_cluster_valid_path_names returns information on all valid shared disks, including clustered shared volumes, for a SQL Server failover cluster instance. |
rwestMSFT |
randolphwest |
12/16/2024 |
sql |
system-objects |
reference |
|
|
|
>=sql-server-2016 || >=sql-server-linux-2017 |
[!INCLUDE sqlserver]
Returns information on all valid shared disks, including clustered shared volumes, for a SQL Server failover cluster instance. If the instance isn't 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. 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. 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 the disks that are in the cluster resource group associated with the instance. They're the only disks that can be used for data or log file storage.
[!INCLUDE sssql19-md] and previous versions require VIEW SERVER STATE permission for the [!INCLUDE ssNoVersion] instance.
[!INCLUDE sssql22-md] and later versions require VIEW SERVER PERFORMANCE STATE permission on the server.
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;