SQL Server Management Studio's plan viewer can be difficult to understand and use, especially when a large plan doesn't fit on the screen.
Answering the question, “which operation has the highest cost” can feel like finding a needle in a haystack.
So, to make to make it easier, we've created a FREE query plan visualization tool that highlights the high cost operations, so that you can prioritize which ones to optimize first.
We’ve made it easy to find the aspects of your query plan that are having the greatest impact on your database performance so that you can quickly focus on key problem areas with the greatest tuning potential.
By installing the Spotlight Tuning Pack plugin, you can access this capability right inside SQL Server Management Studio.
High impact nodes are highlighted. You can click on each operator for more details, expand or collapse any branches, and navigate around the plan with ease.
Watch this short video to learn more about Spotlight Tuning Pack Plan Visualization.