DTM DB Stress

You may be about to start a web server based database but before starting it, you must put it to stringent verification and testing procedures to ensure that your database server and application doesn’t get blown off when the load on your server is excessively high. In short, you must have a fair idea of how many requests and operational modifications your server system can handle in order to do any required modifications in terms of scalability. For undertaking effective testing, you must use an application that provides you with 100% error proof testing and their subsequent results. DTM DB Stress v.1.11.00 is a powerful application that would let you do efficient testing of your server and generate detailed results which can be easily interpreted.

DTM DB Stress v.1.11.00 is primarily meant for stress testing in a simulation based environment and applies the tests to server parts of database applications and information systems. Apart from such server parts, this application can successfully verify the efficiency of complete Database Management Systems and servers. This powerful application would assist you in sending requests related to OLAP and OLTP, to the server for testing. The OLAP requests include request related to execution of queries and OLTP includes various operations with data of the database like addition, modification and deletion. While doing the test, you will have full control related to the number, type and priority of the task execution requests that you send to the server. A complete support for all major database interfaces is included in the program which includes IDAPI, ODBC, OLE DB and Oracle Call Interface.

Summing it up, DTM DB Stress v.1.11.00 is a powerful utility for testing your servers for their stress handling capabilities, leading it to score four and a half rating points on the scale of five.

DTM DB Stress is a utility for stress and load testing the server parts of information systems and database applications, as well as DBMSs and servers themselves. Also it is suitable for database benchmarking and performance tuning. 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. HTML and Excel reporting options with report comparison options helps the user to find critical leaks.
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/2008/2012 Server family, Vista, Windows 7 and Windows 8(desktop). The x64 edition of the stress tool is available for registered users upon request.