Cluster Information

  • Comments posted to this topic are about the item Cluster Information


  • Thanks for pointing out the 2 DMV's!! If someone wanted to run this script automatically across all servers in their environment to find the clustered servers and collect information about them, I'd include ServerProperty('IsClustered') and ServerProperty('MachineName').

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • Good point. I didn't include that information as I assumed you should already know what clusters you have. But still a great addition to the code.



  • great script. can certainly use this as a supplement to cluster monitoring that i have in place at my company. in case we miss an alert for a failover, we can use this to find the active node and check it against what the active node should be.

    Excellent work.



  • Is there a way to tell if the nodes are actually up and available?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply