PREEMPTIVE_OS_LOOKUPACCOUNTSID

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

  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

⇐ Back to index