Techiio-author
Started by David HarrisonOct 2, 2021

Open
How to track adaptive joins

0 VIEWES 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 0 VIEWES SHARE

Query Store is unable to capture information about adaptive queries because adaptive plans change on every execution.

I couldn't find an event to capture adaptative query plan execution, is there any event for that?

I tried to create a session to capture query_post_execution_showplan and filter showplan_xml to capture only adaptative queries, but there isn't a pred_compare for xml fields, so it's impossible to filter the showplan_xml field, I would need to capture the showplan_xml for all the queries being executed and filter later, that's not a good solution.

So, the main question: How can I track adaptative joins in a way that allows me to identify how many executions are using nested join and how many are using hash joins?

0 Replies

You must be Logged in to reply
Trending Technologies
15
Software40
DevOps46
Frontend Development24
Backend Development20
Server Administration17
Linux Administration26
Data Center24
Sentry24
Terraform23
Ansible83
Docker70
Penetration Testing16
Kubernetes21
NGINX20
JenkinsX17
Techiio-logo

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Developed and maintained by Wikiance
Developed and maintained by Wikiance