Currently when you apply AppInsight for SQL, all databases, including default databases like MSDB, model, etc are selected. We would like to be able to select which databases we monitor.
This is already possible today, albit it in reverse. Once AppInsight for SQL is applied, simply unmanage the Databases you don't wish to monitor. This will remove any status and prevent them from alerting.
I thought I looked this over in detail before posting this but I didn't see where I could unmanage specific databases. Can you point me in the right direction please?
When I try and unmanage a specific SQL performance counter it in turn unmanges all of the performance counters in there a way to only unmanage one?
It is not possible to unmanage a specific component in SAM. You can however remove the warning and critical thresholds so they do not alert. That should provide the desired result.
All I ever see which this module is a sea of errors and warnings even for servers that have ZERO databases running or 10 databases running. I can't depend on the status since it always "thinks" something is wrong.
