Database Performance Testing and Benchmarking

The database performance is quantity of job than can be executed per second or another period. The performance is usually measured in terms of set of metrics. Most important are response time latency, number of SQL statements (or transactions for OLTP systems) or another requests that can be executed per second, number of rows can be fetched per second.

The database server or solution benchmarking is a process of estimating a performance in order to find if the server or solution can serve enough client requests. At the other hand we have performance tuning and performance comparison. The performance tuning goal is to optimize mentioned database metrics: minimize response time, maximize number of transactions per second, etc. The performance comparison allows to identify best hardware configuration, software version or even database system for your solution.

DTM DB Stress is a testing tool to measure the performance of database servers and server side of database solutions. It allows the user to collect information about:

• Database server (as software) performance.
• Performance of the server side of the solution (procedures, triggers, etc).
• Operating system resource usage and loading (threads, processes, handles).
• Hardware utilization at the server and client sides (RAM, CPU, storage, etc).

An important product feature is capability with normal and stress activity of the clients. The stress activity is extremely large number of requests, huge data sets of another non-standard server or database application usage. In this state the software user can find bottlenecks or even general server, database or solution limitations.

Download free demo (?) version of DTM DB Stress and try it out now!

See also

• How to create stress test?
• Can the stress tool help me?