Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question
add comment

1 Answer

up vote 5 down vote accepted

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)).

share|improve this answer
    
I'm guessing I won't get any info on that wait type, but this info is more useful anyway. Thanks! –  msgisme Jul 1 '13 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... –  Aaron Bertrand Jul 1 '13 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 '13 at 18:05
    
@msgisme this may have some info too: connect.microsoft.com/SQLServer/feedback/details/383878/… –  Aaron Bertrand Jul 1 '13 at 18:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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