BFScripts to pass bind variables to your SQL scalability test

BFScripts to pass bind variables to your SQL scalability test
Amit Parikh May 12, 2008

Quite often, applications and databases are load tested to ensure that they are meeting
the needs of the business they support. While using the Toad Development Suite for
Oracle, I am able to take advantage of Benchmark Factory, which offers capabilities to
create and conduct a variety of database load testing projects.
One of the challenges testers face is automating the input of bind variables into their
load test, allowing them to execute the transactions in the manner intended by
application usage, but without the need to intervene by manually entering bind values.
Below I will explain how I created and executed a load scenario using the BF Scripting
Wizard. The load scenario is comprised of one database power user which needs to
generate a report for their constituents. The user will populate a temp table with the
data that is needed and then subsequently run a query against that temp table to
retrieve the data they for the report. The goal is to execute this user with concurrent
load by increasing the number of virtual users executing this transaction so that I can
identify any degradation that may occur using the “Run Reports” found in Benchmark
Factory.
Overview of Benchmark Factory
Benchmark Factory is a database ...