Symantec IGA

Expand all | Collapse all

How to enhance Task Persistance DB performance when running on MS SQL Server

Jump to Best Answer
  • 1.  How to enhance Task Persistance DB performance when running on MS SQL Server

    Posted 03-10-2017 03:59 PM

    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



  • 2.  Re: How to enhance Task Persistance DB performance when running on MS SQL Server
    Best Answer

    Posted 03-13-2017 04:37 PM

    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

    Thanks

    Palaka Bhattacharya

    Support Delivery Manager

    1-630-210-7191

    bhapa02@ca.com



  • 3.  Re: How to enhance Task Persistance DB performance when running on MS SQL Server

    Posted 07-10-2017 04:32 AM

    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.

     

    Thanks! Alok