The database load testing is a process of bulk data inserting and measuring some performance metrics like response time, memory usage or CPU loading. There are two tools by DTM soft suitable for database load testing: DTM DB Stress and DTM Data Generator. With both tools the user can run bulk test data loading into database.
DTM DB Stress is a load testing tool that runs and manages continuous set of requests to the server of the OLAP (query execution) and OLTP (adding/loading, modifying and deleting data in the database) types with detailed reports (HTML, Excel, visual).
There are a few simple steps:
The following table explores differences between the tools for SQL load test purpose:
|DTM DB Stress
|DTM Data Generator
|Does the tool support concurrent activities for SQL load testing?
|Does the tool provide detailed performance report?
|No, basic measures only
|Can the tool emulate different client activities at once?
|No, data loading only
|Does the tool allow user to watch for server performance counters?
|Yes, with performance counter module
|Can the tool automatically recognize master-detail relationships in data generation process?
|Can the tool use existing data set?
|Yes, text/CSV files only
|Yes, database or external file
|Does the tool provide random data source?
|Yes, without automatic rule generation
|Does the tool support SQL Server Bulk loading mode?