What are two possible ways to achieve this goal?

You have a vendor application that uses a scalar function.
You discover that the queries for the application run slower than expected.
You need to gather the runtime information of the scalar function.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
A. Enable the Include Actual Execution Plan option.
B. Enable the Display Estimated Execution Planoption.
C. Create and then enable a profiler trace.
D. Create and then enable an extended events trace.
E. Run the Database Engine Tuning Advisor.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.