Stress Test Execution Report

Summary

PropertyValue
Report created28-Oct-2016 20:39:52
DTM DB Stress version 1.24.03, build: Oct 8 2016 08:35:08, UNICODE, x86
Default Database ConnectionConnected to SQL Server Native Client 11.0: .///NorthwindOriginal [NorthwindOriginal]
Database System and VersionMicrosoft SQL Server [ 10.50.2550 ]
Active (enabled) Tasks in the Project2 of 2
Project Initialization Time, seconds 0.3170
Total Project Execution Time, seconds 7.4950
Execution ModeBy individual task properties, concurrent mode

Task #1 "Retrieve object description"

PropertyValue
Number of Concurrent Threads3
SQL scriptselect CategoryID, Description from Categories where Description is not null order by CategoryID
Task PriorityNormal
Task Initialization Time, seconds 0.1570
Total Task Duration, seconds14.5840
ThreadNoExecuted,
times
Average speed,
Iterations per second
Average duration,
Seconds
Maximum duration,
Seconds
Minimum duration,
Seconds
Connection time,
Seconds
Disconnection timeTotal duration,
Seconds
12284471.3165 0.0021 0.0540-0.0000 0.0140 0.0020 4.8460
22276466.1069 0.0021 0.0550-0.0000 0.0140 0.0020 4.8830
32266466.7353 0.0021 0.0560-0.0000 0.0090 0.0020 4.8550

Task #2 "Retrieve object description (top 25)"

PropertyValue
Number of Concurrent Threads5
SQL scriptselect top 25 CategoryID, Description, Picture from Categories
Task PriorityNormal
Task Initialization Time, seconds 0.1600
Total Task Duration, seconds25.1330
ThreadNoExecuted,
times
Average speed,
Iterations per second
Average duration,
Seconds
Maximum duration,
Seconds
Minimum duration,
Seconds
Connection time,
Seconds
Disconnection timeTotal duration,
Seconds
12119421.6076 0.0024 0.0570 0.0010 0.0140 0.0020 5.0260
22017395.9560 0.0025 0.0580 0.0010 0.0110 0.0020 5.0940
31987389.8372 0.0026 0.0570 0.0010 0.0090 0.0010 5.0970
42083415.0229 0.0024 0.0570 0.0010 0.0090 0.0010 5.0190
52196448.4378 0.0022 0.0560 0.0010 0.0090 0.0020 4.8970