Question

4
Replies
1182
Views
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
Posted: 26 Apr 2018 10:32 EDT
Last activity: 7 Jun 2018 5:44 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.