Bookmark and Share
How to find SQL Server Cluster Nodes and Shared Drives
(Publish Date: 2014-7-30 4:19pm, Total Visits: 489, Today: 2, This Week: 3, This Month: 3)

1. Find name of the Node on which SQL Server Instance is Currently running

   SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS [CurrentNodeName]

++ If the server is not cluster, then the above query returns the Host Name of the Server.

2. Find SQL Server Cluster Nodes

   a. Using Function
   SELECT * FROM fn_virtualservernodes()

   b. Using DMV
   SELECT * FROM sys.dm_os_cluster_nodes

3. Find SQL Server Cluster Shared Drives


   a. Using Function
   SELECT * FROM fn_servershareddrives()

   b. Using DMV
   SELECT * FROM sys.dm_io_cluster_shared_drives

4. Other queries

   select SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'),SERVERPROPERTY ('COMPUTERNAMEPHYSICALNETBIOS')

   select SERVERPROPERTY ('COMPUTERNAMEPHYSICALNETBIOS')