sys-dm-io-cluster-shared-drives-transact-sql.md

title	sys.dm_io_cluster_shared_drives (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	database-engine, pdw
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sys.dm_io_cluster_shared_drives_TSQL sys.dm_io_cluster_shared_drives dm_io_cluster_shared_drives_TSQL dm_io_cluster_shared_drives
dev_langs	TSQL
helpviewer_keywords	sys.dm_io_cluster_shared_drives dynamic management view
ms.assetid	c8fcced8-c780-49dc-99bd-6beb3ca532c4
author	stevestein
ms.author	sstein
monikerRange	>=aps-pdw-2016||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.dm_io_cluster_shared_drives (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-pdw-md]

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.

Note

To call this from [!INCLUDEssPDW], use the name sys.dm_pdw_nodes_io_cluster_shared_drives.

Column name	Data type	Description
DriveName	nchar(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_id	int	Applies to: ssPDW The identifier for the node that this distribution is on.

Remarks

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 [!INCLUDEssNoVersion] instance. Only disks listed by this view can be used to store data or log files for this instance of [!INCLUDEssNoVersion]. The disks listed in this view are those that are in the cluster resource group associated with the instance.

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.

Permissions

The user must have VIEW SERVER STATE permission for the [!INCLUDEssNoVersion] instance.

Examples

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

See Also

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)