I am new to APM
Can someone give me some info how to shrink the APM database.
Its currently at 45GB.
You did not say if your database was Postgres or Oracle. If it is Postgres, there are two KBs on that topic:
But I would also be concerned with what you are doing to generate so much data
- Too many users
- Too many transactions being monitored
- Too many session maps
- Too many defects or large defects
- Large defect request/response body size. ?
I created a Tech Note on Database Maintenance that can be found on the community that may help
Further to Hal's advice, just an FYI that there is currently a limit to what you can do to limit the DB size growth with the existing Data Retention Settings for user related data & there is an idea logged to improve that:
"Enhanced control of the APM DB size growth": https://communities.ca.com/ideas/235723341
Thanks for the info.
The procedure made very little difference.
But I found that there are very big files in the APM PATH\data\pg_log folder.
File size of 1-2GB.
Not sure why they are so big.
I have attached a portion of 1 of the files.
The pg_log directory contains Postgres log files and there will be one for each day (with corresponding date in the name).
If you stop Postgres you can remove the files & then restart it.
If the default logging parameters (log_*) have been changed in file APM PATH\data\postgressql.conf it might explain why the logs files are so large or it may just be due to a large volume of APM DB activity which would be mainly due to CEM work.
Hope it helps
Retrieving data ...