2

Is there any option to show "Include Actual Execution Plan" plus query cost and recommended indexes in SQL Profiler?

I see Showplan XML, but it shows only the execution plan without recommended indexes :/

It's working perfect when I run the query from SQL Server Management Studio and Include Actual Execution Plan.

  • 2
    No, but if you run sp_BlitzCache it will get the cached plan, the estimated cost, and any high value missing index requests. – Erik Darling May 24 '18 at 18:49
  • Thx. I check this tomorrow :) – anjela May 26 '18 at 12:35
0

FWIW, the missing index info is there is is just Profiler that doesn't bother to show it. If you dig into the underlying XML you will see it. Ans since Profiler has been deprecated and MS haven't done any work on it since 2010, we can't expect any change here. If you use Extended Events, the "new" (if we consider 2008 being new) trace engine, then you will find that the missing index is there as well. But the GUI for XE doesn't show the graphical representation for the plan in the first place, only the raw XML. I suggest you follow Erik's recommendation, most probably a more productive path.

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.