Internal use only. A pre-emptive wait in the eXtended Events interface.
SQL Server The Extended Events architecture enables users to collect as much or as little data as is necessary to troubleshoot or identify a performance problem. Extended Events is configurable, and it scales very well.
Extended Events are replacing the deprecated SQL Trace and SQL Server Profiler features
PREEMPTIVE_XE_TARGETFINALIZE wait will be seen when the session is switched to pre-emptive mode to terminate a monitoring target.
How to reduce this wait
This is a rare wait to see as monitoring and auditing use this method to collect data and the actual wait time should be very low. Bugs were seen in 2012 and earlier versions so if you observe high wait times, log a call with Microsoft support.
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.
- Google Search for sqlserver - PREEMPTIVE_XE_TARGETFINALIZE
- Ecosia Search for sqlserver - PREEMPTIVE_XE_TARGETFINALIZE
- Bing Search for sqlserver - PREEMPTIVE_XE_TARGETFINALIZE