I have noticed that appinsight SQL does not have the option to disable a particular component monitor. Certain parameters show always critical status and i need to disable certain component monitors. Is there any way to do this?
Have the same issue - just started testing with our DBAs and while they like it, they also don't want to see certain things! Answer I got was to ramp the thresholds up so high for certain components that they never appear red. You can't disable most components with AppInsight due to the way it works - it uses single queries to populate multiple metrics. Only thing I saw was one or two components like "Top Indexes for Database" can be disabled - but in general, you can't disable like a traditional template.
Removing the threshold entirely will ensure the metric is never in a warning or critical state. This is the recommended approach if you do not care about a particular metric. This can be set at both the template level so that it applies to all SQL instances, or at the application level when you want control over just a single SQL server instance.
Nice - yup. Will give that a go and see if it keeps the DBAs happy.
