Description
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
DBAs
Suggested solutions
- Reduce the number of Active Directory queries
- Investigate Windows Event Viewer for any Active Directory messages
- Fix any Domain Controller performance issues
- Investigate network performance between the SQL Server and Domain Controller
- Simplify Active Directory group membership. Avoid excessive nested groups
Additional research
PREEMPTIVE and Non-PREEMPTIVE
Something to watch out for when using IS_MEMBER() in TSQL