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. Use SQL Replication Monitor to view and resolve any errors with SQL replication. For assistance with SQL replication, contact Microsoft.