cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Have the ability to capture parameter details for sql statements

Have the ability to capture parameter details for sql statements

Have the ability to capture what the parameters are that are being used.  This helps how to tune the sql.

2 Comments
Level 10

I would like to second this as a feature request.  It would be very good to have the option to capture bind variables for different iterations of the same named query.  For instance when you have a named query that has 50 or more executions in an hour, and the objects it is hitting include many *different* partitions  it is good to have a sample of of what the parameters passed to the query were so that you can verify what is happening.

Level 8

Yes, 100%.  The first thing I ask for when a performance issues comes in on a stored proc is, which parameter values are being slow.  It helps to run execution plans and reproduce the issue while tuning, not to mention the ability to see parameter sniffing and data skew in large tables.