Cool Tips‎ > ‎Clustering‎ > ‎

Clustering - Get Basic Cluster Information

Applicability:

                 SQL Server 2000:        Not Supported
                 SQL Server 2005:        Tested
                 SQL Server 2008:        Tested
                 SQL Server 2008R2:    Tested
                 SQL Server 2012:        Not Tested        

Credits:

Author:   Unknown
Date:      14 May 2009

Description

Retrieve the cluster active node, plus a list of nodes and shared drives available.
It is very basic information, but easier than grabbing time from the DBA if cluster manager is locked down (as it should be).
 

Code

cellPadding=0 width=876>

 

PRINT ' **** Cluster Information ****'
PRINT ' '
PRINT ' The following is information on the cluster you are connected'
PRINT ' '
PRINT '... Name of all nodes used and are part of this failover cluster'
SELECT NodeName As Cluster_Node_Name FROM sys.dm_os_cluster_nodes
PRINT ' '
PRINT '... Node which is the active '
SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS Active_Node_Name
PRINT ' '
PRINT '... Drive letters that are part of the resourse group which contain the data and log files'
SELECT DriveName as Shared_Drive_Name FROM sys.dm_io_cluster_shared_drives

 


ċ
Get Cluster information.sql
(1k)
Andy Hughes,
Jun 23, 2012, 1:04 AM
Comments