search cancel

UIM - database monitoring probes - design change request when using MCS Enhanced.

book

Article ID: 242044

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

This technical article documents a design change request for the sqlserver probe and other database monitoring probes that might behave in a similar way. 

Current Design:
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).

Expected Design:
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.

 

Environment

Release : 20.3

Component : UIM - SQLSERVER

Resolution

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".