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:
|Option||DTM DB Stress||DTM Data Generator|
|Does the tool support concurrent activities for SQL load testing?||Yes||No|
|Does the tool provide detailed performance report?||Yes||No, basic measures only|
|Can the tool emulate different client activities at once?||Yes||No, data loading only|
|Does the tool allow user to watch for server performance counters?||Yes, with performance counter module||No|
|Can the tool automatically recognize master-detail relationships in data generation process?||No||Yes|
|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||Yes|
|Does the tool support SQL Server Bulk loading mode?||No||Yes|