DTM DB Stress 1.08.00

DTM DB Stress 1.08.00 provides you a utility for stress testing the server parts of information systems and database 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. Built-in data generator for parameters of dynamic SQL statements makes test jobs more flexible. The stress tool supports all common database interfaces: ODBC, IDAPI, OLE DB, or even Oracle Call Interface.

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.

DTM DB Stress is a true Win32 application, known to be compatible with the following operation systems: Windows 98 and ME, Windows 2000 family, Windows XP (Home and Professional), Windows 2003 Server family.

DTM DB Stress is a specialized stress testing tool for server parts of information systems (databases), related applications and database servers themselves. The purpose of the tool is to allow database developers and QA specialists see how applications and hardware handle heavy data traffic, multiple simultaneous connections, competing queries and transactions.

DTM DB Stress allows database developers and administrators create and set up a nonstop flow of server queries in the form of OLAP (query execution) or OTLP (adding, deleting or editing data in databases). Program users can alter both the quantity and priority of queries for databases or related applications.

DTM DB Stress comes with a test package that has a big set of various database tasks in the form of SQL statements. The program allows launching multiple copies of one task, running parallel in different threads. It is possible to set individual priorities for each task, including priorities. Thus, the package lets any database administrator test current database performance in order to estimate the maximum threshold or to properly plan for future system upgrades.

DTM Soft is a well-known software company specializing in developing database processing and reporting utilities. The company signature is remarkable simplicity and efficiency of all software titles DTM Soft has developed and released. DTM Schema Reporter is the latest addition to the company's database processing software product line that includes titles like DTM SQL editor, DTM Migration Kit, DTM Data Generator, DTM Data Editor and DTM Schema Reporter.

Why DTM DB Stress:

1. Five task execution methods, dozen of settings and task properties will help you to customize your stress test.
2. Values File allows you to emulate variations in the end-user activity.
3. Command line support allows you to automate stress testing process.
4. Built-in simple data generator enables you to make test jobs more flexible.
5. Console mode helps to schedule software execution.
6. Performance Counters plug-in creates report based on local and/or remote system counters. [Sample] report.
7. Show plan plug-in for SQL server includes SQL statement execution plan to HTML report.
   

Major Features:

1. Detailed and customizable measuring HTML [sample] or MS Excel-compatible text [sample] report for stress test project execution.
2. Execution statistics in text or graphic format.
3. Database independent. You can test your Microsoft SQL Server database as well as IBM DB2 or Interbase/Firebird database. The stress tool supports all common database interfaces: ODBC, IDAPI, OLE DB, or even Oracle Call Interface.
4. DTM DB Stress is a true Win32 application that supports Windows 98/ME/2000/XP/2003/Vista.
   

Enhancements:

1. Show Execution Plan Plug-in for SQL Server New options
2. Project properties Built-in data generator for parameters of dynamic SQL statements
   

Requirements:

1. ODBC32
2. IDAPI
3. OLE DB
4. Oracle Call Interface