Face 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.
Updated March 11th, 2016
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.
All DPA versions
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.
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.
You can change the five years of daily data and the 90 days of hourly data. The parameters for these are listed below: