Question
4
Replies
1121
Views
LLoyds Banking Group
Posted: April 26, 2018
Last activity: June 7, 2018
Closed
List of database tables that can be cleaned up regularly to improve the performance
Hi All-
We are working in multi node environment where we are seeing loads of queue data and other reference data getting written to the logs thus impacting performance of the application servers.
So I am looking for some information on what tables can be truncated on regular basis and any order in which they can be regularly cleaned up without impacting performance.
Thanks,
Chaitanya
Hi Chaithu,
The PDN article might help you in improving the performance of your system:
https://pdn.pega.com/performance-guidance-production-systems-system-settings/performance-guidance-production-systems
Regards,
Hemanth