locked
Disable Monitoring for Read Only SQL Server Database RRS feed

  • Question

  • I have configured my SQL Server Environment for monitoring using the Low Privilege access described in the management pack documentation.  However, I have several instances across a couple of different servers that have read only databases in the instance.  How can I disable monitoring/discovery ONLY for these databases, not the entire instance itself?  I have found numerous places where I can disable the entire instance, but not the individual databases.

    Any ideas?

    Monday, March 10, 2014 2:33 PM

Answers

  • Create a group of those database instances, and disable the database related discoveries for that group. If the databases have already been discovered, then you will need to run the equivalent of Remove-DisabledMonitoringObject in your environment in order to remove those database instances. Monitoring will automatically stop then.

    Jonathan Almquist | SCOMskills, LLC (http://scomskills.com)

    • Proposed as answer by Jonathan Almquist Tuesday, March 11, 2014 5:24 AM
    • Marked as answer by Juke Chou Monday, March 24, 2014 3:09 AM
    Tuesday, March 11, 2014 5:24 AM

All replies