SQL extended event captured only the estimated execution plan but no actual execution plan My SQL instance version is Microsoft SQL Server 2014 (SP3-CU-GDR) (KB4535288)
I am troubleshooting the application time-out and the time-out SELECT query is quite simple. It only takes less than 1 second when I manually run it...
I used extended events query_pre_execution_showplan &amp; query_post_execution_showplan to capture the estimated/actual execution plan. It shows only the estimated execution plan but without the actual execution plan.
Looks like SQL instance just generated the estimated execution plan...
Any thoughts?
Many thanks,
I imagine that you aren't seeing the &quot;post execution&quot; event because the client canceled the execution.