Database Management
Interpreting PREEMPTIVE_XE_GETTARGETSTATE Waits in DPA
PREEMPTIVE_XE_GETTARGETSTATE is associated with SQL Server retrieving the state of an Extended Events target. The wait alone does not confirm a user-facing performance problem. Monitor it if there is no observed impact; if users are affected, review the associated query and correlate its activity with the affected timeframe. Confirm an Extended Events session’s purpose before changing it, since DPA may use it to collect deadlock information.
First published date
Last published date
Overview
DPA may show the SQL Server wait type PREEMPTIVE_XE_GETTARGETSTATE in query wait data. This wait is associated with SQL Server retrieving the state of an Extended Events target. By itself, it does not establish that users are experiencing a performance problem.
Product section
Resolution
Resolution
- Check whether application slowdowns or other user-facing performance issues occurred during the same period as the wait.
- If there was no observable impact, continue monitoring the trend. Do not change the query or an Extended Events session based on this wait alone.
- If there was an impact, select the affected query in DPA and review its SQL text. Correlate the query and other wait data with the affected timeframe to help identify whether the activity is related to an application workload, monitoring, or an administrative operation.
- Before changing an Extended Events session, confirm its purpose. DPA can use Extended Events to collect deadlock information.