Forecast for Databases - part of the Forecast family of integrated performance and load testing products

Performance and load test databases by directly injecting load over various database interfaces.

Used for testing two-tier applications or directly testing the database tier within a multi-tier application.  The client to database server actions are recorded to a trace that accurately captures the database control and SQL statements.

The resulting trace is converted to a replay script in a language appropriate for the interface used for load generation including ODBC, JDBC or ADO (also known as ADO .Net). 
The scripts are sufficiently high-level that only modest SQL scripting skills are required yet the full power of direct access to the database API and industry standard programming languages is available.

Features

• For ODBC, all client calls are recorded while running the client application to generate a test script.
• For ADO and ODBC, Microsoft SQL Profiler server recordings can be used to generate replay scripts.
• For JDBC, client-side jars are instrumented to produce recordings that are then used to generate replay scripts of Java clients.
• User actions can be identified during recording to create high level transaction timers  i.e. "user experience" timings.
• A clear, high-level replay script is generated that replicates all client-server actions.  The script clearly shows the SQL statements and database actions.
  
• The complexities of ODBC and ADO are hidden by support libraries to simplify the scripts.
• SQL statements and database actions can be parameterised using the standard Forecast mechanisms for fine control of variable input data.
  
• At runtime, every database action is timed in addition to top level 'user experience timings' to help pinpoint database bottlenecks.
• All the usual Forecast features are available for advanced test scenarios, input data, monitoring and result analysis.