I have two instances in the last week where a DROP command for an Extended Events session has taken over a day to complete, sitting with the wait: PREEMPTIVE_XE_CALLBACKEXECUTE.

Can anyone explain what this wait type means?

More Background Info: In the first instance, I ran a T-SQL command to drop the session and it completed a day later. Using sp_whoisactive, I saw that the query was waiting on PREEMPTIVE_XE_CALLBACKEXECUTE.

During this time, Object Explorer's queries to gather metadata were being blocked and recieving lock-timeouts, but there were no other complaints (or so I thought at the time).

I tried to drop another session on Friday, and the same behavior occurred, except it didn't just go away after a day as the with the first event. Instead, I found out this morning that the client application could not connect. It was being blocked by the DROP EVENT SESSION query.

A restart of the SQL Service cleared out the blocking query.

I can't find anything that helps to diagnose what this wait type this is... and why my event sessions won't drop like they should. Can you help?

Server Info: SQL 2008 R2 Enterprise with SP2

1 Answer 1


I believe this issue was fixed in SQL Server 2008 R2 SP2 Cumulative Update #1 (10.50.4260):

KB #2511963 - FIX: Query stops responding in SQL Server 2008 or in SQL Server 2008 R2 if the query alters or stops an Extended Events session

They don't mention your specific wait type but I have seen others who have and stated that this fix resolved their issue. So, if you are literally on SP2 with no CU (10.50.4000), you should consider at least that CU, or a later one (the most recent CU for 2008 R2 SP2 is CU7 (10.50.4286)).

  • I'm guessing I won't get any info on that wait type, but this info is more useful anyway. Thanks!
    – msgisme
    Jul 1, 2013 at 17:53
  • @msgisme the only thing I can offer about the wait type is that pre-emptive waits, in general, are things SQL Server waits for outside of SQL Server, and hence usually has little control over. And, sadly, the wait types are not fully documented and I don't expect them to ever be... Jul 1, 2013 at 17:54
  • Yeah, the most descriptive piece of info I found was is this blog post: blogs.msdn.com/b/psssql/archive/2009/11/03/… It says more info coming in 2010 :(
    – msgisme
    Jul 1, 2013 at 18:05
  • @msgisme this may have some info too: connect.microsoft.com/SQLServer/feedback/details/383878/… Jul 1, 2013 at 18:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.