YOU’RE TROUBLESHOOTING A SLOW RUNNING PROBLEM AND YOU’D LIKE TO SEE...

4. You’re troubleshooting a slow running problem and you’d like to see which

indexes, if any, are being used by the slow query. You’re configuring a SQL

profiler trace. Which events should you include to see the actual execution

plan in XML?

A. Showplan XML Statistics Profile

B. SQL:BatchCompleted

C. Showplan XML

D. RPC:Completed

Answer A is correct. The Showplan XML Statistics Profile event will capture

the actual execution plan. Showplan XML captures the estimated plan and this

may be different from the actual plan. Neither option in Answer B or D will

capture any plan.