Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Database Performance Analyzer (DPA) > Reduce the size of the CONV_METRIC_DETAILS tables in the DPA repository

Reduce the size of the CONV_METRIC_DETAILS tables in the DPA repository

Updated October 4, 2017

Overview

When DPA is monitoring a database instance on a VM with a large number of disks, the CONV_METRIC_DETAIL tables grow rapidly, resulting in a large DPA repository database. If necessary, use one of the following resolutions to reduce the size of the repository.

Environment

  • DPA, all versions

Cause

DPA is monitoring a database instance on a VM with a large number of disks.

Resolution

Select one of the following workarounds:

  • Decrease the amount of data being stored
  • Disable VM Disk Device metrics

Decrease the amount of data being stored

  1. Click Options > Administration > Advanced Options.
  2. Click the VM Options tab and select your vSphere server from the dropdown menu.
  3. Reduce the values of the following parameters:
    • VSPHERE_METRICS_CLEAN_DAYS_OF_DETAIL
    • VSPHERE_METRICS_CLEAN_DAYS_OF_TEN_MINUTE
    • VSPHERE_METRICS_CLEAN_DAYS_OF_HOURLY
    • VSPHERE_METRICS_CLEAN_DAYS_OF_DAILY

Disable VM Disk Device metrics

  1. On the DPA dashboard, click the name of any monitored database instance that collects Disk Device metrics.
  2. Click the Resources tab.
  3. Click the Disk Device tab.
  4. Disable each metric:
    1. Click Settings.
    2. Select Custom.
    3. Clear the Enable Data Collection checkbox.
    4. Click the Save As Default button.

By clicking Save As Default, you disable the metric for all database instances that collect Disk Device metrics.

 

 

Last modified

Tags

Classifications

Public