View your Failover Cluster from the DMV’s

Just a quick post this time , I was fumbling around the DMV’s the other day looking for a specific Availability group DMV that I just couldn’t remember the name of – I think we have all been there before with some of the DMV names! 🙂

Whilst I was combing through various combinations of sys.dm_hadr and sys.Availability I stumbled across a couple of gems that I thought would be nice to share.

• sys.dm_hadr_cluster
• sys.dm_hadr_cluster_members
• sys.dm_hadr_cluster_networks

But before we get carried away with what they show, let me show you what things look like from the Failover Cluster Manager so that we can be sure that I am not pulling a fast one.

So lets see what the DMV’s say:

Ok so this is all well and good it saves having to use Failover cluster manager to save some time in a crucial time critical situation – but what do we see if the cluster is down?

So that’s it, just a quick one to share today that may just make life a little easier 🙂

Thanks for reading.