The QUEST_PERFORMANCE_REPOSITORY is growing quite large and getting bigger every week.
How can we prevent this from getting even bigger?
The Performance Analysis Repository will grow for up to 5 years, however you should see very little growth after the first 6 months.
At that point the size should be fairly static unless you continue to add additional agents that are using this repository.
The repository can grow larger than the initial size depending on how busy the monitored instance is, and how much data is being transmitted to the repository from the middleware.
The Repository Database keeps the data collected from the monitored host based on the Time Pyramid resolution values set in the PA GUI client.
These values can be adjusted in Agent Administration -> History Collection -> Time Pyramid tab (see online help)
Lowering these values will keep less repository data for that instance ONLY.
There is no global setting for this, each instance must be done individually.