Wednesday, April 9, 2014
Auditing Bug - high cpu, slow login, slow performance
So after months of working with SAP, we've finally identified a major problem that was affecting login performance and probably performance in general. The culprit was Auditing! The auditing folder was not being cleared out as it should be. To be more precise, the files in the Auditing subfolder are supposed to be continually roll over and get reduced to 0 KB. In my case, the files are stacking up and never getting removed. If I stop the SIA, and rename the auditing folder and create a new auditing folder that is empty, then start the SIA again, the performance problems go away. SAP has recommended a permanent fix to run a database script which will remove unique key constraints in the repo.