Metric Intelligence table sa_metric_type is growing by thousands of records daily

Paul Bloem
Tera Expert

We're using ACC Monitoring and Metric Intelligence, and for some time now we've been having issues with our ACC Agents showing down when they're actually running fine. One thing I noticed in the ACC MID Server logs and in the ECC queue is a massive number of references to the sa_metric_type table. When I took a look at that table, I noticed that it is growing every day by several thousand records, and most of them have the same name with a bunch of numbers at the end:

PaulBloem_0-1678373286029.png


I'm hoping someone else that is using ACC + Metric Intelligence can confirm if this is the behavior in their instance as well. 


Best,
Paul

1 REPLY 1

Sayali_Suryawan
Tera Guru

Hello Paul

 

If you are using a specific source, such as solarwinds, scom, or newrelic, you can disable the automatically generated metric types by making them inactive.

 

For this open table "SA Metric Type Registration (sa_metric_registration)," find the source you want to stop the automatically generated metric, open the source record, and select "Type default mode - Inactive."

 

This will not generate any automatic metric types in the "sa_metric_type" table.

 

Please mark my answer if it was helpful.

 

Thank you.