When using Active Roles, consider the following possible SQL bottlenecks:
-
Database locks. Too many Active Roles services using the same shared database might cause deadlocks on tables, which will impact performance. In such cases, users could see delays in the Active Roles clients.
-
Geographic latency.
-
Insufficient resources, such as memory or hard disk.
-
Replication. While Active Roles can display the replication information in the Active Roles Console, One Identity recommends using the SQL Replication Monitor to view and resolve any errors with SQL replication. For assistance with SQL replication, contact Microsoft.