This technical article documents a design change request for the sqlserver probe and other database monitoring probes that might behave in a similar way.
When a configuration profile is created using sqlserver enhanced template, all the metrics/checkpoints will be enabled by default in the probe cfg, even though only a few metrics are enabled in MCS UI.
The probe will query the monitoring server for all the metrics, but the spooler will filter the qos based on the metrics enabled in MCS UI(plugin_metric.cfg).
Whatever the checkpoints/metrics enabled in MCS UI, probe should query the monitoring server only for those metrics.
Why? There will be an impact on the performance of monitoring servers, let's say, if the customer enables only 4 to 5 metrics, but the probe will query for around 40 metrics for every interval.
Release : 20.3
Component : UIM - SQLSERVER
This changes is part of UIM engineering and product managements backlog:
F121831 (Case 32929721) to "Limit metric collection as per configured MCS profile for DB probes".