Which database performance metrics DTM DB Stress provides?

There are metrics to analyze database or solution performance. The following list shows metrics supported by the database stress tool.

• Task^* initialization time (seconds).
• Task total duration time (seconds).
• Average thread^** speed, a number of executed iterations or transactions^*** per second.
• Average duration, seconds per thread execution.
• Maximum and minimum thread duration, seconds.
• Connect and disconnect time, second to connection establishment and termination.
• Thread level SQL execution time.
• Thread level data fetching time.
• Total thread duration, seconds

^* - the task is a set of one or more client emulation activities with the same behavior.
^** - one thread corresponds to one client activity emulator also known as a virtual user.
^*** - one iteration corresponds to one or more transaction depends on the task definition and settings. In other words, it is one task's script execution.

Server Side Metrics

All mentioned metrics are collected and stored at the client side where DTM DB Stress executing. The user should operate with system performance counters to add server side metrics to the report. Please refer to your DBMS manual for details.

Report Comparison

The enterprise edition if the stress tool allows the user to compare results of a few job executions or different jobs results. It provides comparison results as HTML report (sample) or set of diagrams.

See Also

• Download free demo (?) version of DTM DB Stress and try it out now!
• Database performance.
• Quick Video Tour