Question

4
Replies
1121
Views
Close popover
Sri Krishna Chaitanya Manchala (ChaithuLBG)
LLoyds Banking Group

LLoyds Banking Group
GB
ChaithuLBG Member since 2014 6 posts
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

Data Integration System Administration
Moderation Team has archived post