Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cluster Information Expand / Collapse
Author
Message
Posted Wednesday, April 15, 2009 8:38 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, June 23, 2015 6:19 PM
Points: 330, Visits: 1,193
Comments posted to this topic are about the item Cluster Information


Post #698101
Posted Friday, May 8, 2009 10:44 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, June 23, 2015 2:10 PM
Points: 1,620, Visits: 1,568
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 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #713156
Posted Friday, May 8, 2009 11:16 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, June 23, 2015 6:19 PM
Points: 330, Visits: 1,193
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
Posted Saturday, May 9, 2009 10:01 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 11:57 AM
Points: 1,033, Visits: 1,051
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
Posted Monday, September 3, 2012 9:15 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 2, 2015 3:41 AM
Points: 91, Visits: 569
Is there a way to tell if the nodes are actually up and available?
Post #1353579
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse