question

Ryan avatar image
Ryan asked

Wait Type PREEMPTIVE_OS_AUTHORIZATIONOPS

What does the wait type PREEMPTIVE_OS_AUTHORIZATIONOPS mean?

I have a service which is executing a stored procedure to log historical data. It has been running fine for a few months. Out of the blue I found we were no longer logging data and the service calls to SQL were timeing out because the connection pool was full. The activity monitor showed hundreds of processes with that wait type, no wait resource and no block by.

The only google hits on it talk about this being added in 2008.

sql-server-2008wait-type
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered

Based on some info at MVP - Christian Bolton's blog, the name suggests that it could be a wait associated with latency talking to your domain controller for authentication.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tom Staab avatar image
Tom Staab answered

I don't have a specific answer for you, but I hope this helps.

You can find a nice overview of waits here: http://www.digitalconcourse.com/dropzone/MSCOMM/PASSMN/PASSEVT20090616/Joe%20Sack%20Performance%20Troubleshooting%20with%20Wait%20Stats.pdf

The author (a Microsoft Dedicated Support Engineer) explains:
"Preemptive mode used in SQL Server for external code calls, CLR with an UNSAFE assemblies, APIs that could block for extended periods (example –extended stored procedures)"

He breaks down the preemptive wait type naming convention like this:

PREEMPTIVE_<category>_<function or class name>

"API function or call can often be found on MSDN"

Unfortunately, I have not been able to find anything specific about AUTHORIZATIONOPS in MSDN or elsewhere.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.