1

I was given a large Execution plan and I'm trying to find the nodes connected to high costs. SSMS offers a search util, however, I did not find the option that searches for the cost value in percent. Given my image below, how do I search for a node causing 21 percent of the cost? The second input allows to select equals and contains. Is it possible to search for operations that cost more than 15 %?

SSMS ExecutionPlan search

4

A much better option would be to use SentryOne's Free Plan explorer. It is 1000% better than SSMS.

You can also have it configured to install it as SSMS addin and then when you right click any plan, it will allow you to open in Plan explorer.

  • I had hoped for an SSMS solution. Thanks for the tipp to use the alternative tool. – Bernhard Döbler Aug 11 at 21:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.