|
|
|
Load testing. DTM DB Stress and DTM Data Generator usage.
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.
Using this tools the user can create bulk test data loading into database.
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 plugin |
No |
| Can the tool 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 support SQL Server Bulk loading mode? |
No |
Yes |
How to create simple load test with DTM DB Stress?
There are a few simple steps:
- Specify connection information for target database
- Create new task with required number of load threads
- Use INSERT sql statement with set of parameters as task definition
- Associate each parameter with column of value file or test data generator
- Save the task and run it
- Analyze required metrics in progress and/or after test job completion
Download free demo (?) version of DTM DB Stress and try it out now!
See also
|
|
|
|
|
|
|
See also
|
|
Articles
|
|
|
|
|
|
|
|
Related Products
|
|
|
|
|
|
|
|
|
|
|
|
• On-line