Useful commands for SQL server clustering TSQL

— Find the current server is clustered or not

SELECT ‘IsClustered’, SERVERPROPERTY(‘IsClustered’)

—Find SQL Server Cluster Nodes
SELECT * FROM fn_virtualservernodes()

—Find name of the Node on which SQL Server Instance is Currently running
SELECT SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) AS [CurrentNodeName]

— Find shared drives for cluster
SELECT * FROM fn_servershareddrives()

— Useful statements for cluster

SELECT CAST( SERVERPROPERTY(‘InstanceName’) AS NVARCHAR(128)) AS ‘InstanceName’
SELECT CAST( SERVERPROPERTY(‘MachineName’) AS NVARCHAR(128)) AS ‘MachineName’
SELECT CAST( SERVERPROPERTY(‘ServerName’)AS NVARCHAR(128)) AS ‘ServerName’
SELECT CAST( SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’)AS NVARCHAR(128)) AS ‘ComputerNamePhysicalNetBIOS’