Wanted to check if anyone is facing issues with the Task Persistence DB when running on MS SQL Server. Whenever the Explore and corelate is submitted we seeing millions of records being populated and also noticing that the tables are being locked and deadlocks happening. We opened up ticket with CA but wanted to check if anyone else had similar issues . Also we using the merge replication. I did indexed the database . Object12_5 table is causing most of the problems . Please help
Would recommend you still consider getting to root cause of this in your existing support ticket 00693599
We have asked folks from CA Services to comment further
Support Delivery Manager
Could you please check at DB level out of box stored procedure exists??
We faced similar latency issue in our environment but we are using Oracle DB. If you confirm I can share a Java utility which you have to configure for cronjob script call. This will make connection against DB and clean the persistent DB using store procedure.