Performance questions about taskpersistence

Products

• 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

Issue/Introduction

“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?"

 

 

 

Environment

14.x
Identity Manager

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

Resolution

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.