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. Cr

eate and then enable a profiler trace.

D. Create and then enable an extended events trace.

E. Run the Database Engine Tuning Advisor.

Explanation:

A: An execution plan is the result of the query optimizer-s attempt to calculate the mosteffici

ent way to implement the request represented by the T-SQL query you submitted. To generate the first execution plan, you can enable the Include Actual Execution Plan option.

D: SQL Server Extended Events can be used to capture User Defined Function(UDF) co

unts

References: https://www.mssqltips.com/sqlservertip/4100/how-to-find-udfs-causing-sql-server-performance-issues/