This wait accumulates while SQL Server is waiting for an Active Directory query to complete. It occurs while listing group members like in in the xp_logininfo stored procedure and the sys.login_token management view. This wait frequently appears along side PREEMPTIVE_OS_LOOKUPACCOUNTSID. If Windows Authentication is being used some values in this wait type are expected. If values are high see the suggested solutions below. Pre-emptive waits are different from regular (emptive) waits as their execution is controlled by an external processes such as the operating system

Resolved by


Suggested solutions

  1. Reduce the number of Active Directory queries
  2. Investigate Windows Event Viewer for any Active Directory messages
  3. Fix any Domain Controller performance issues
  4. Investigate network performance between the SQL Server and Domain Controller
  5. Simplify Active Directory group membership. Avoid excessive nested groups

Additional research

Something to watch out for when using IS_MEMBER() in TSQL

⇐ Back to index