How Bind Variables and Bind Values are handling in DB Optimizer
When generating test cases for a tuning job, if the original SQL that needs to be tuned had bind variables that need to be set, then you will see red ‘x’ next to the statement and if you hover your mouse over the red ‘x’ you will balloon help on the error message letting you know that the captured statement needs a value for the variable
By clicking the arrow head next to the ‘insert into master.#palette’ statement or on the red ‘1 error detected’ message brings up the following window. And here you can set the bind variable value for this test case.
In terms of capturing the values of the bind variables, as of yet we are not doing that for SQL Server.