Database Stress Testing Software Features

Environment

Operating systems support Windows 2000, XP, Vista, 7, Windows 8/10 (desktop), Server 2003, 2008, 2012.

Connectivity Options

What kind of unified database interfaces are supported? ODBC, IDAPI, OLE DB or Oracle Call Interface.
x64 edition of the stress tool supports ODBC interface only.
Does the database performance test tool support desktop database formats? Yes: Microsoft Access, DBF, Text/csv, Microsoft Excel, Paradox.
Does the product support any DBMS-specific features? Yes, for Microsoft SQL Server, Oracle, DB2, Sybase, MySQL, Informix, PostgreSQL and Interbase/Firebird.

Task Properties

Does the product support parameterization? Yes, using text (tab-delimited, CSV or with custom separator) value file or built-in data generator.
Does the stress tool have data generator for SQL statement parameterization? Yes, read more.
How many virtual users the tool can emulate? It depends on available system resources like CPU loading and database client configuration.
The upper limit is about 2000 per computer.
Can multiple tasks and threads be executed simultaneously? Yes.
Can multiple tasks be executed sequentially? Yes.
Can a few stress tasks be united to a group? Yes, read more.
Does the database stress tool support task priority selection? Yes, normal, low and high priorities are supported.

Database Stress project execution

How are errors reported back to the user by the performance testing tool? As a set of message boxes with source statement. The Error Log file is also available.
What kind of statistics are present in this database stress utility? Text data in data grid format and graphics for top 5 tasks or threads depends on settings.
Does the software support execution report? Yes, HTML [sample], counters [sample] or text (Excel compatible) [sample].
Can the stress tool save actually executed statements to SQL file? Yes.
Can the software export fetched data or add them to report? Yes, to the disk file only.
Can I load bulk data to test database with DTM DB Stress? Yes, read more.
Can the stress utility save execution plans of SQL statement to a report? Yes, for MS SQL Server only with Show Plan feature.
Can I include system or database performance counters in the report? Yes, with Performance Counters module.
What kind of additional tools and options are present in the software? SQL console allows you to execute custom SQL statement(s).
Can I run my loading test in unattended mode or by schedule? Yes, the tool supports command line node.
Can the software show execution results as diagram? Yes, with Enterprise edition only. Read more.
Can I compare results of a few executions? Yes, with Enterprise edition only [sample comparison report].

Assistance/Help

Is help for the tool built into the product? Yes, Windows HTML Help.
Does the help for the tool available online? Yes, see online help
Does technical support included in the product price? Yes, for the first year.

See Also