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.
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.
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: