In the Query Plan Comparison section, we were able to take a query plan from the production environment that was not performing as expected and validate that, when running the same query in the development (dev) environment with a production-like database, we were able consistently response the issue. And then, through comparative analysis of the cached query plan from production (an estimated execution plan) and the actual execution plan from dev, we created hypotheses from the data we observed, until we found the root cause. Last, we tested a fix for the root cause of the issue by hinting the query, which, again by comparing plans, determined that the new plan was better than the old plan, and should now be implemented in production.

In the Query Plan Analyzer section, we were able to take a query plan that had been captured in the production environment through an XEvent...