How to run a SQL Profiler Trace to include the Query Execution Plan.
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.