Parameterize Query & Substitue Values

[Alfredo Giotti]

Hello Gentlemen,

Please excuse my ignorance. Do you have any videos displaying how to use the two features listed in the subject line. I have read the online documentation and I am confused. 

Best Regards,

[Ramesh Meyyappan]

Hello Alfredo

We don't have videos explaining these features yet, but we have a step-by-step guide to get you started (both of these topics are listed under 'Examples on how to use SQLTest' in http://www.sqltest.org/Documentation)

Setting up a parameterized insert test: http://www.sqltest.org/Documentation/HowToSQLTestInsertExampleWithParameterization

Setting up an insert test with value substitution: http://www.sqltest.org/Documentation/HoToSQLTestInsertExampleWithValueSubstitution

What you need to know is there can be 2 connection strings (they can be same or different):

One under General Settings (under Menu -> Settings) that supplies the parameter/substitute values using stored procedure.

The other is part of the workload (main window) that uses the parameter/substitute values, the target server.

The column names returned from the stored procedure should be same as the parameter name.

The stored procedure can return different parameter/substitute values based on @Connection, @ConnectionString, @Thread, @BatchIndex, @CommandText. For example the same stored procedure can return different parameter values based on batch content (@CommandText).

Let me know if this step-by-step guide is helpful or needs some more explanation.

I will try to get a video made in the next possibility

Best Regards

[Alfredo Giotti]

Hello Ramesh,

Good to hear from you! Awesome tool you have here. We just purchased the full unlimited license.

I will give these examples a go at it and let you know if I need any further assistance.

Best regards

[Ramesh Meyyappan]

Hello Alfredo

Here is the link to the video with hands-on example that uses Parameterize Query & Substitute Values feature:

http://www.sqlvideo.com/AllVideos/Optimize-for-Ad-Hoc-Workloads---SQL-Server-Parameter

Let me know if you have additional questions.

Best Regards