SQL Server 2005 has a great dynamic management view named sys.dm_io_cluster_shared_drives . If you have clustering and want to know what
shared disk/s which is/are used by clustered SQL Server instance run the following query.
SELECT DriveName
FROM sys.dm_io_cluster_shared_drives
ORDER BY DriveName
Thursday, March 5, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment