I’m very excited for this because I’ve wanted to put something together about this topic for a long time.
What inspired me is that I’ve really come to appreciate that there’s different pieces of information collected with the execution plan itself depending on where I get the plan from. Understanding what’s collected, where, and why can help make a difference when trying to troubleshoot and performance tune.
I get most of my query plans from a shady vendor with an unmarked van in a Walmart parking lot.