Cluster Information

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Rudy Panigas » Cluster Information

Cluster Information

Rate Topic

Display Mode

Topic Options

Author

Message

Rudy Panigas

Posted Wednesday, April 15, 2009 8:38 PM

Old Hand

Group: General Forum Members
Last Login: Wednesday, September 21, 2016 11:17 AM
Points: 346, Visits: 1,281

Comments posted to this topic are about the item Cluster Information

Post #698101

Robert Davis

Posted Friday, May 8, 2009 10:44 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, September 15, 2016 8:35 AM
Points: 1,633, Visits: 1,619

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
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master, SQL Server MVP
Database Engineer at BlueMountain Capital Management

Post #713156

Rudy Panigas

Posted Friday, May 8, 2009 11:16 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, September 21, 2016 11:17 AM
Points: 346, Visits: 1,281

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

Post #713191

S. Kusen

Posted Saturday, May 9, 2009 10:01 PM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, September 1, 2016 2:47 PM
Points: 1,070, Visits: 1,108

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

Post #713638

UnicornsRreal

Posted Monday, September 3, 2012 9:15 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, February 12, 2016 5:48 AM
Points: 91, Visits: 621

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

Post #1353579

« Prev Topic | Next Topic »

Permissions