PREEMPTIVE_OS_AUTHENTICATIONOPS

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

  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

PREEMPTIVE and Non-PREEMPTIVE
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