Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > DPA repository: Data retention policy

DPA repository: Data retention policy

Updated March 11th, 2016

Overview

If you need to reduce the amount of storage that DPA uses, you can change the settings that specify how much historical data is stored in the DPA repository. Changing the CLEAN_DAYS_OF_DETAIL setting has the biggest impact, because 80 to 90% of the storage consumption is usually for detailed data. 

Environment

All DPA versions

Detail

Default behavior

DPA is configured to hold 30 days of detailed second-by-second data out of the box. DPA will summarize to hourly data but it still keeps the rolling 30 days of detail. After 30 days, DPA summarizes the hourly to daily and removes the details for anything older than 30 days (keeping hourly for 90 days). After 90 days, DPA retains only daily summarized data. It retains this data for five years.

Changing the default behavior

To change this default configuration, click Options > Adminstration > Advanced Options > DB Instance Options, and then select a database Instance.

You can change values for the following settings. More information about each setting can be found within the DPA UI.

  • CLEAN_DAYS_OF_DETAIL (default value is 30 days)
  • CLEAN_END_HOUR (default value is 3AM the day following when the cleaner started)
  • CLEAN_INTERVAL_DAYS (default value is 1 day)
  • CLEAN_START_HOUR (default value is 10PM local DPA time)

 

You can change the five years of daily data and the 90 days of hourly data. The parameters for these are listed below:

  • CLEAN_DAYS_OF_TREND (default value is 1825 days)
  • TREND_HOURLY_DAYS (default value is 90 days)

 

*You may need to shrink your database datafiles in order to reclaim this space after a successful run of the cleaner process with the settings changed.  The default run of this process is 10PM.

Last modified

Tags

Classifications

Public