How to archive CRM Middleware tables
Since the performance of our CRM production system is very bad, I'm trying ways to improve it. The first step I took towards that is to delete the application logs from SLG2. There were like 58,000+ logs that have been deleted which were expired.
Now, I see that the size of the middle-ware tables, SMW3_BDOC* are huge. They are like 500-1000MB. What's the best way to archive them initially and then periodically to keep the size in control, may be not more than 50MB? Are there any standard programs that helps to achieve this?
Also, the background job SM06_REORG02 has been running all the day long. Is this due to the huge middle-ware tables?
Thanks for the help.