locked
Remove and reinstall or temporarily disable SQL MPs? RRS feed

  • Question

  • We have recently installed SCOM R2 and several management packs, and are in the process of tuning alerts.  There's a lot of noise at the moment, and we'd like to stop SQL monitoring temporarily while we deal with some of our more pressing needs, like the Exchange MP. 

    My questions is, if I decide to remove the SQL MPs entirely, and then reinstall at a later date, are there any problems I will encounter doing this?  I have exported the SQL override MP that I created to store the overrides I've created thus far, so that I can import these when I reinstall the SQL MPs at a later date.  Temporarily disabling the monitoring looks a bit time-consuming, so I'd prefer to just remove the pack and then reinstall later if that is feasible.

    Monday, November 29, 2010 6:25 PM

Answers

  • Changing the enabled property on the discoveries won't shut off sql monitoring.  To get to the quesiton, no harm in deleting and re-trying at a later date.
    Microsoft Corporation
    • Proposed as answer by Vivian Xing Tuesday, November 30, 2010 8:01 AM
    • Marked as answer by Vivian Xing Thursday, December 9, 2010 9:55 AM
    Tuesday, November 30, 2010 3:58 AM
  • I also would like to share the following information:

    How to Remove a Management Pack:

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

    How to Import a Management Pack in Operations Manager 2007

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

     


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Vivian Xing Thursday, December 9, 2010 9:55 AM
    Tuesday, November 30, 2010 8:03 AM

All replies

  • Disable the discoveries for SQL DB Engine  and SQL Reporting Services (of all flavors 2000/2005/2008); these are the discoveries that are targeted at Windows Server and are the "top" of the discoveries that run for SQL, for example, once a DB Engine is discovered, then SQL File Group, SQL Agent, SQL Databases are all discovered.

    "Fear disturbs your concentration"
    Monday, November 29, 2010 9:24 PM
  • Changing the enabled property on the discoveries won't shut off sql monitoring.  To get to the quesiton, no harm in deleting and re-trying at a later date.
    Microsoft Corporation
    • Proposed as answer by Vivian Xing Tuesday, November 30, 2010 8:01 AM
    • Marked as answer by Vivian Xing Thursday, December 9, 2010 9:55 AM
    Tuesday, November 30, 2010 3:58 AM
  • I also would like to share the following information:

    How to Remove a Management Pack:

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

    How to Import a Management Pack in Operations Manager 2007

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

     


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Vivian Xing Thursday, December 9, 2010 9:55 AM
    Tuesday, November 30, 2010 8:03 AM