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


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

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index