I have a large query with performance issues. I want to run it in live query statistics mode, but instead of the execution plan, I see the inscription "Waiting for query plan".
In sys.dm_os_waiting_tasks I see that the session blocks itself with wait_type CXPACKET, CXCONSUMER, HTDELETE.
At the same time, I can simply build estimated execution plan without any problems.
Please advise what steps I can take to sort out performance issues.