SQL Profiler Question

  • I noticed in Profiler that Show Plan Statistics/Show Plan All are available. However, when I select them and then run the trace I can see that the ShowPlan events are occuring, but there is no text data. Bascially the only info I see is the start time, login name, application name and spid. 

    I thought that information about the query details was supposed to show up so I could use it for analysis. Is there a setting I'm missing?

  • In the data columns to display, select BinaryData and you should see this.

    Regards

    Shaji

  • Got it - thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply