You have SQL Server on an Azure virtual machine that contains a database named DB1.
You have an application that queries DB1 to generate a sales report.
You need to see the parameter values from the last time the query was executed.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Question

You have SQL Server on an Azure virtual machine that contains a database named DB1.

You have an application that queries DB1 to generate a sales report.

You need to see the parameter values from the last time the query was executed.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Sana Mehak · Accepted Answer

Enable Lightweight_Query_Profiling in DB1

Sana Mehak · Accepted Answer

Enable PARAMETER_SNIFFING in DB1

Sana Mehak · Answer

Enable Last_Query_Plan_Stats in the master database

Sana Mehak · Answer

Enable Last_Query_Plan_Stats in DB1

Sana Mehak · Answer

Enable Lightweight_Query_Profiling in the master database

List of questions