Metric Intelligence table sa_metric_type is growing by thousands of records daily

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-09-2023 06:49 AM - edited ‎03-09-2023 07:47 AM
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:
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
- Labels:
-
Operational Intelligence
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-25-2024 02:38 AM
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.