Finding the nodes in a Failover Cluster

I was recently asked by a friend, how to find the names of the nodes that are participating in a failover cluster.

The Dynamic Management View sys.dm_os_cluster_nodes will give this information. The following script will return the list of Node names in the cluster.

Note that the query was run on a 3 Node cluster, so the result set displays the 3 Nodes in the cluster.

If the same command is run on a stand alone machine, it would not return any node name indicating it is not a cluster.

– Bru Medishetty

Using the right terminology.

I am a regular visitor to SQL Server Forums at SQLServerCentral and see some users posting their question, issues and problems. Some of these questions tends to confuse even the seasoned campaigners and at the same time would not give the complete picture of what is being asked. I saw a user posting a question seeking internals of Transactional Replication and  in the next sentence asks about Transactional logs. I was not sure what was the area the user was looking for.

Similarly few days back a user was requesting the suggestion of other users in setting up Database Mirroring and was referring one servers as Publisher (A publisher is the source server / system in a Replication setup), where as when questioned by a fellow user, he was referring the Principal Server as publisher and cleared the doubtful minds.

There is nothing wrong in being a learning IT professional, it  is OK to make mistakes but it should not be done repeatedly and due consideration needs to be taken with the technical terminology.

– Bru Medishetty