My client is facing huge increase on table TST03 due to frequent use of spool data, and this is starting to affect performance of the production system.
Although currently it is fine with deleting spool data after 10 days by house keeping job,
I believe once user increase (when other entities get into production later), start using the system and output spool,
it will result in worse performance for the system.
If anyone experienced a system using a huge number of spool data,
can you advise me what kind of action you took for this?
Here are some details.
System: SAP ERP 7.2
Quantity of Spool Data: Around 7,000 per day (80% of these are immediate output from smartforms)
The current size of table TST03: 90GB (DB total is 300GB)