Description
This wait accumulates while SQL Server is waiting for an Active Directory query to complete. This typically occurs when using the function IS_MEMBER or the sys.login_token management view. 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