There are several ways to check for the cluster configuration, the fundamental one is access to the “Failover Cluster Management” console (“cluadmin.msc”) in windows. Another way is to execute a DMV scripts in your SQL Server Management studio. We going to introduce 2 useful scripts in this article to help you identify your all your cluster nodes and also identify which on is the active one.
In order to get a list of all cluster nodes, please find how to use the DMV scripts for your SQL Server environment here.
Next, you can execute the following query to identify which cluster node your SQL Server is currently running on.
Some times execute a script is much more easier than clicking through the GUI in windows to get just a simple information.