locked
WMI?? RRS feed

  • Question

  • can anyone explain me what is the need of WMI ,wen can someone congifure WMI in a cluster,if i configure WMI on passive node and restart the services of the passive node does the active node goes up,what is the DBA's concern in this scenario,will their be any downtime in the application,probably how much?in a active-passive cluster setup.

     

    Thanks,Bt

    Wednesday, September 14, 2011 6:37 AM

Answers

  • Hi Bt,


    I really feel confused about ‘does the active node goes up’, could you please explain that?
    If you want to configure WMI in failover clusters in SQL Server 2008 or later, you could configure it in the passive node first and after restarting, set this passive node to be active node, and configure WMI in the previous active node.
    Hope this helps.


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Edited by Iric Wen Monday, September 19, 2011 7:45 AM
    • Marked as answer by Stephanie Lv Friday, September 23, 2011 9:41 AM
    Monday, September 19, 2011 7:42 AM

All replies

  • Hi,

    Here are some links; -

    http://msdn.microsoft.com/en-us/library/aa394572(v=vs.85).aspx

    http://technet.microsoft.com/en-us/library/ee692772.aspx

    http://msdn.microsoft.com/en-us/library/aa394582(v=vs.85).aspx

    I hope this helps.

    Kind Regards,

    Kieran.


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood
    Wednesday, September 14, 2011 7:39 AM
  • Hi bt,

    WMI can be used in all Windows-based applications, and is most useful in enterprise applications and administrative scripts. You can write WMI scripts or applications to automate administrative tasks on remote computers but WMI also supplies management data to other parts of the operating system and products. You can configure WMI to show server status in SQL Server tools.
    For more information please see:  How to: configure WMI to Show Server status in SQL Server tools  and Creating a Cluster with WMI

    Hope this helps.

     


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Thursday, September 15, 2011 8:03 AM
  • thanks kieran,i will read these links
    Monday, September 19, 2011 7:07 AM
  • Thanks a lot iric,i could now get what WMI is but can you please explain the scenario i have asked in the above question not the actual WMI theory.
    Monday, September 19, 2011 7:09 AM
  • Hi Bt,


    I really feel confused about ‘does the active node goes up’, could you please explain that?
    If you want to configure WMI in failover clusters in SQL Server 2008 or later, you could configure it in the passive node first and after restarting, set this passive node to be active node, and configure WMI in the previous active node.
    Hope this helps.


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Edited by Iric Wen Monday, September 19, 2011 7:45 AM
    • Marked as answer by Stephanie Lv Friday, September 23, 2011 9:41 AM
    Monday, September 19, 2011 7:42 AM