-
Title
Performance issues affecting multiple Active Roles clients which is specifically tied to Active Roles Virtual Attributes -
Description
When working with Active Roles Virtual Attributes in multiple Active Roles clients, results are returned, but the operation is processed noticeably slower than similar operations which contain only native Active Directory attributes.
The Microsoft SQL Server which is hosting the Active Roles configuration database is healthy and is not showing any general performance-related issues.
-
Cause
The indices on the CVSAValues and/or the CVSAIndexedValues database tables are seriously fragmented and need maintenance.
It is expected that any heavily-used SQL index will need periodic maintenance in order to maintain optimal performance.
Enhancement ID 279996 has been created to include built-in functionality which makes it easier to rebuild SQL database indices as part of a SQL maintenance place.
-
Resolution
WORKAROUND
In the SQL Server Management Studio, using an account with the necessary access, run the following two tSQL commands on the Active Roles Configuration database:
ALTER INDEX ALL ON CVSAValues REBUILDALTER INDEX ALL ON CVSAIndexedValues REBUILDSTATUS
An Enhancement Request has been created to integrate this functionality into Active Roles.Product Management will evaluate the request and this feature may become available in a future release of the product.There are no guarantees that this specific enhancement request will be implemented in a future release. For more information regarding our Enhancement Request policy, refer to our Global Support Guide on the Support Portal at: https://support.oneidentity.com/essentials/support-guide/ -
Change Request
279996