Can someone point me to any documentation on maintaining the size of the DPA database? Is there an archive feature? Does the application do this automatically?
Just a small additon.
There was a change in release 2022.2 which also have an influence on the repository size.
After a SQL statement runs, DPA stores the associated plan data in the
CONSPT
table in the DPA repository. In earlier versions, DPA stored plan data for 5 years by default (the retention period for daily data). This retention period could cause theCONSPT
table to be very large.In new installations of DPA 2022.2 and later, DPA stores plan data for 90 days by default (the retention period for hourly data). This change reduces the size of the
CONSPT
table.If you upgrade from DPA 2022.1 or earlier, the default retention period for plan data is not automatically changed. However, you can change it by editing the advanced option
CLEAN_CONPT_RETENTION
.
regards
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.