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.
Bạn đang xem 4. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P162 PPTX