sys.dm_io_cluster_shared_drives (Transact-SQL)

sys.dm_io_cluster_shared_drives (Transact-SQL)

 

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

This view returns the drive name of each of the shared drives if the current server instance is a clustered server. If the current server instance is not a clustered instance it returns an empty rowset.

System_CAPS_ICON_note.jpg Note


To call this from Parallel Data Warehouse, use the name sys.dm_pdw_nodes_io_cluster_shared_drives.

Column nameData typeDescription
DriveNamenchar(2)The name of the drive (the drive letter) that represents an individual disk taking part in the cluster shared disk array. Column is not nullable.
pdw_node_idintApplies to: ssPDW

The identifier for the node that this distribution is on.

When clustering is enabled, the failover cluster instance requires data and log files to be on shared disks so that they may be accessed after the instance fails over to another node. Each of the rows in this view represents a single shared disk which is used by this clustered SQL Server instance. Only disks listed by this view can be used to store data or log files for this instance of SQL Server. The disks listed in this view are those that are in the cluster resource group associated with the instance.

System_CAPS_ICON_note.jpg Note


This view will be deprecated in a future release. We recommend that you use sys.dm_io_cluster_valid_path_names (Transact-SQL) instead.

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

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

SELECT * FROM sys.dm_io_cluster_shared_drives;  

This is the result set:

DriveName

---------

m

n

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

Community Additions

ADD
Show:
© 2016 Microsoft