How to run a SQL Profiler Trace to include the Query Execution Plan.

Version 1

    Details

    How to run a SQL Profiler Trace to include the Query Execution Plan.


    Resolution

     

    1.  Launch SQL Profiler.

    2.  SelectFile>> New Trace and connect to the SQL server being used for the HEATSM database.

    3.  On the General tab, use the Standard (default) option for Use the template:

    4.  On the Events Selection tab, check the box for Show allevents.

    5.  Expand the Performance Events and include the Events value of Showplan XML Statistics Profile.

    6.  ClickRun.