PREEMPTIVE_OS_SECURITYOPS

Description

This wait accumulates while SQL Server is performing certain security operations such as account delegation through Linked Servers. Small to moderate values are expected. If values are excessive 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. If possible, consolidate TSQL code that frequently accesses Linked Servers. Example: convert row by row processes on Linked Servers to batch processes
  2. Ensure that Linked Servers are configured as per best practice (see additional research below)

Additional research

PREEMPTIVE and Non-PREEMPTIVE
Recommendations for Linked Server Performance Improvement

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