Execution Plan Analyzer
is a feature that will cut your query troubleshooting time at least by half or more. With it you can easily see the costliest plan operators
based on different properties like IO, CPU, Number of rows, Cardinality, Relative cost, etc... Can't find a node that is on a particular index? Need that specific nested loops join? Not a problem anymore. With plan searching
this now as easy as pie. And just when you think things can't get better they are with Execution Plan Auto Analyzer
. It goes through your plan finding most common problems and gives you the usual solution for each one. This feature isn't meant to replace manual analysis but it will find the usual problematic spots that you can fix up fast.