Post reply

Best way to capture SQL Server Cluster related information

  • December 30, 2010 at 9:43 am

    #144526

    Hi All,

    All DBAs who are managing the multiple Clusters, also have the tedious task to maintain the complete information about the SQL Server Cluster like Cluster Name, Groups, Resources, IP's involved etc. It needs to be complete, consolidated and easy to update.

    Kindly share how are you managing the complete information regarding the SQL Server Clusters.

    Thanks in advance.

    With regards,

    Ankur

  • December 30, 2010 at 11:41 pm

    #1268016

    Powershell offers good flexibility. Here[/url] is a nice example.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • December 31, 2010 at 3:37 am

    #1268064

    Hi Pardeep,

    Thanks for the reply. I must say that it is worth to visit your site 'http://www.sqldbadiaries.com' and know more about the sql server. Kudos to you !!! Gr8!

    I have the scenarios which contain the Clusters on SQL Server 2000 and 2005.

    Right now, I used to capture the information about every detail regarding Clusters, by capturing the screenshots of all the screens of 'Clusteradministrator', (which is one of the easiet of the ways to manitain all information about clusters :-P)

    Now is there is any other way/method to capture data in excel sheet . Or can we use any other scriipt which donot use the Poweshell to collect details of Cluster?

    With regards,

    Ankur

  • December 31, 2010 at 5:48 am

    #1268081

    Hi Ankur,

    I am not making use of any scripts to get the details of the Cluster. Since there will be hardly any changes in Cluster configuration, we usually refer the design document created when the Cluster was built.

    To create a script you have to workaround cluster.exe and then use sqlcmd to generate a .csv output file.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • January 7, 2011 at 3:13 pm

    #1270946

    Hi All,

    Adiga: Thanks for your response.

    I am sure all must be maintaining some documents/sheets for capturing Cluster related info., please share.

    Thanks in advance

    With regards,

    Ankur

  • January 7, 2011 at 4:17 pm

    #1270971

    I would think WMI would be able to query out all that information..

    CEWII

  • January 7, 2011 at 4:30 pm

    #1270978

    Pls check this link for getting basic Clustered SQL Server information

    http://sqlserver-qa.net/blogs/tools/archive/2008/03/11/get-sql-server-clustering-information-with-dmvs-and-select-statements.aspx

    Thank You,

    Best Regards,

    SQLBuddy

  • January 8, 2011 at 2:35 pm

    #1271091

    Hi Ankur

    i always produce full graphical documentation using Visio. The document details all node details and disks, etc. It provides an "at a glance" view of the current configuration, even service account names. It can be tedious but it's well worth the effort

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • January 12, 2011 at 6:35 pm

    #1272756

    Hi All,

    Many Thanks to Elliott Whitlow, sqlbuddy123 and Perry Whittle for their responses. 🙂

    With regards,

    Ankur

Viewing 9 posts - 1 through 8 (of 8 total)

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