Azure SQL DB Capture Parameter Values Per Query

Question

Is there a way to capture the value of a parameter for each individual execution of a query? We suspect a parameter, though not necessarily sniffing, issue.

Answer 1

Hi Peter Shore •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you want to capture the value of a parameter for each individual execution of a query.

Could you please refer to the below link if matches to your requirement:

https://www.sqlshack.com/working-with-parameters-in-the-sp_executesql-stored-procedure/

If not, could you please provide more information about the usecase here so that we can assist you better.

Thank you.