Performance questions about taskpersistence
search cancel

Performance questions about taskpersistence


Article ID: 42613


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On


“We are experiencing slow response times on IDM tews services. We are unsure at the moment the source of the delay but the DBA's have indicated wait times at the IO level on IDM tables. The question, based on a DBA report is, what is CA's stance on adding indexes to the tables for task persistence?"





Identity Manager

Any version of Identity Manager with High Utilization and low garbage collection on task persistence


There is certainly nothing wrong with adding indexes to the taskpersistence tables and in this case it help with not only garbage collection clean up, but also with the processing of everyday user requests.

Additional Information

The reason that we do not have these added OOTB is because they are only needed and created on a case by case bases based on the customer’s environment.

The customer, you in this case, would have to create them on your own. In more recent versions of IM there are some indexes on tables and these indexes are managed by IM, however you, as the customer that owns the database can create more if you need more.