Johan Bijnens wrote:
I just export the plan and its consumption statistics from the plan cache.
1 file with all consumption details, 1 .sqlplan file per plan
Yes, we can get plan from either plan cache or QueryStore as text into an XML file - but how would you programmatically extract from specific nodes using PowerShell? I'm wanting to parse the XML for specific information like a list of what indexes or operations are used by the plan.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho