SQL deadlocks and slow alarm processing when soitoolbox --purgeClearedAlerts is running
Article ID: 129692
CA Service Operations Insight (SOI)
soitoolbox --purgeClearedAlerts nn when SOI Services are up and running we are facing lot´s of sql deadlock messages in the soimgr-debug.log and as a cause of this we are facing very slow alarm processing due to a high amount of jobs in the SOI Manager job queues that are processing slow.
When SOI is up and running and soitoolbox --purgeClearedAlerts runs, it will lock tables to avoid and data inconsistency while removing old Alerts data from the database.
new soitoolbox utility resolved the case. Until it will become general available within an official patch it can be requested through a support case.