Cluster Information

Question

Cluster Information

Rudy Panigas

SSChampion

Points: 10702
More actions
April 15, 2009 at 8:38 pm

#199460

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

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

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

Robert Davis One Orange Chip Points: 28027 More actions · Answer 1

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]

Rudy Panigas SSChampion Points: 10702 More actions · Answer 2

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.

Rudy

S. Kusen SSChampion Points: 10936 More actions · Answer 3

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.

Regards,

Steve

timster Ten Centuries Points: 1033 More actions · Answer 4

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