Tuesday, 8 May 2012

Cluster Information in SQL Server

Script to get Cluster information on any node in the cluster group....

SELECT * FROM   sys.dm_os_cluster_nodes
--OR
SELECT * FROM   Fn_virtualservernodes()


--If accessing across Network

SELECT * FROM   sys.dm_io_cluster_shared_drives