Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > 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 August 29, 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_DETAIL_DISK (available in DPA 12.0 and later)

    Is a subset of VSPHERE_METRICS_CLEAN_DAYS_OF_DETAIL and sets the number of distinct days of vSphere metrics disk detail data to keep. Setting this value lower than the  VSPHERE_METRICS_CLEAN_DAYS_OF_DETAIL allows DPA to keep fewer disk metrics while maintaining more days of the non-disk metrics which can help keep the repository size down if DPA is filling up with disk metrics.

     

    You would see the result when you drill down into an hour on a day older than this setting. All other metrics would still be there, but the Storage metrics would not have any data to display.


    If this value is set to a number larger than VSPHERE_METRICS_CLEAN_DAYS_OF_DETAIL, then the VSPHERE_METRICS_CLEAN_DAYS_OF_DETAIL value will be used.

    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
/*]]>*/