This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How do you maintain the size of the DPA repository database?

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?

Top Replies

cpwolf3 over 1 year ago +1 verified

Oops...I found it. Just had to change my search terminology. support.solarwinds.com/.../DPA-repository-Data-retention-policy

+1 cpwolf3 over 1 year ago

Oops...I found it. Just had to change my search terminology.

support.solarwinds.com/.../DPA-repository-Data-retention-policy
Cancel
Vote Up +1 Vote Down

Cancel
0 fabian.s over 1 year ago in reply to cpwolf3

Just a small additon.

There was a change in release 2022.2 which also have an influence on the repository size.

https://documentation.solarwinds.com/en/success_center/dpa/content/release_notes/dpa_2022-2_release_notes.htm

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 the CONSPT 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
Cancel
Vote Up 0 Vote Down

Cancel