Submit a ticketCall us

AnnouncementsCome see SolarWinds at VMUG Frankfurt

SolarWinds is delighted to attend the upcoming VMUG which will take place at Kap Europa in Frankfurt on June 19th, 2018.

See event details.

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 March 8, 2018

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 Sets the number of distinct days of vSphere metrics detail data to keep.
    VSPHERE_METRICS_CLEAN_DAYS_OF_TEN_MINUTE Sets the number of distinct days of vSphere metrics ten minute data to keep.
    VSPHERE_METRICS_CLEAN_DAYS_OF_HOURLY Sets the number of distinct days of vSphere metrics hourly data to keep.
    VSPHERE_METRICS_CLEAN_DAYS_OF_DAILY Sets the number of distinct days of vSphere metrics daily data to keep.

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