Summary

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 dev environment with a production-like database we were able to get a consistent reproduction of the issue. Then, through comparative analysis of the cached query plan from production (an estimated execution plan) and the actual execution plan from dev, we could create 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 at queries, which again, by comparing plans, determined that the new plan was better than the old plan, which 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 trace and get started on finding what could be negatively affecting performance by using this new...