You want to investigate a long-running query. How can you generate a graphical view of the cached SQL plan?
A. Right-click on the statement and select Visualize Plan in the SQL Plan Cache tab of the Performance Administration view.
B. Add a filter to display long-running queries in the SQL Plan Cache tab of the Performance Administration view.
C. Select the Analysis tab to visualize data in the Data Preview of the long-running query.
D. Paste the long-running query into the SQL Console and double-click it.
|
Download Printable PDF. VALID exam to help you PASS. |
 |