Product Home
DTM DB Stress Online Documentation
General Information
Product profile
Task
Connect
Statistics
Settings
Diagram
Advanced options
Dynamic statements
Command line
Additional Information
Installation
Uninstall
License
Demo and Full versions
Technical support
How to order
Upgrade
Database utilities

Product profile

DTM DB Stress is a utility for stress testing the server parts of information systems and applications, as well as DBMSs and servers themselves. This tool allows you to create and configure a continuous set of requests to the server of the OLAP (query execution) and OLTP (adding, modifying and deleting data in the database) types. At the same time, the user can flexibly change both the number and the priority of this or that type of requests to a database or an application.

The program is useful for any information system developer or any QA department employee who wants to make sure the product under development can work with a large number of simultaneous connections and concurring queries and transactions. Database administrators can use this utility to evaluate the current performance of servers and to make plans about increasing processing power.

A test package consists of a set of tasks. Each task is an SQL statement that will be executed in a loop in the process of testing. Each task can be run as several copies running simultaneously in separate threads. Tasks have different properties and priority.

There are several methods to finish a package:

  1. Manual, when the user himself has to click the Stop button
  2. According to the properties of each task - each copy of each task is executed as many times as specified in its properties
  3. By time - all tasks will be running at least for the number of seconds specified by the user
  4. By the overall number of executed iterations. A package is finished if the overall number of iterations for all copies (threads) of all tasks exceeds the specified value
  5. By the number of times each task is executed. A package is finished when each copy (thread) of each task is executed the specified number of times
  6. By the number of times each thread is executed. A package is finished when thread copy of each task is executed at least the specified number of times
In the last three cases those iterations that are already in process are not interrupted, but executed to an end, that is why the actual number of executed iterations may exceed the specified value or time a little.

DTM DB Stress Screenshot

DTM DB Stress is a true Win32 application, known to be compatible with the following operating systems: Windows 98 and ME, Windows 2000 family, Windows XP (Home and Professional), Windows 2003 Server family and Windows Vista. To be able to work with Windows 95 and Windows NT 4.0, you will have to download an additional library set from our site.