Stress Test Execution Report

Summary

PropertyValue
ProjectCategories test
Report created15-Jun-2008 10:02:44
DTM DB Stress version 1.04.05, build: May 26 2008 11:51:37, ANSI, x86
Default Database ConnectionODBC: LocalServer/sa/dbo/NorthwindOriginal
DBMS and VersionMicrosoft SQL Server [ 08.00.0760 ]
Active (enabled) Tasks in the Project2 of 4
Project Initialization Time, seconds 1.4380
Total Project Execution Time, seconds 2.4840
Execution ModeWith 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
Custom ConnectionODBC: LocalServer/sa/dbo/NorthwindOriginal
Task PriorityNormal
Task Initialization Time, seconds 0.5470
Total Task Duration, seconds 1.5360
ThreadNoExecuted,
times		Average Speed,
iterations/second		Average Duration,
seconds		Max Duration,
seconds		Min Duration,
seconds		Connect Time,
seconds		Disconnect Time,
seconds		Total Duration,
seconds
11019.7239 0.0507 0.0930 0.0160 0.0310 0.0000 0.5070
21015.8228 0.0632 0.1870 0.0160 0.0150 0.1090 0.6320
31025.1889 0.0397 0.0610 0.0150 0.0150 0.0000 0.3970

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

PropertyValue
Number of Concurrent Threads5
SQL scriptselect top 25 CategoryID, Description, Picture from Categories
Custom ConnectionODBC: LocalServer/sa/dbo/NorthwindOriginal
Task PriorityNormal
Task Initialization Time, seconds 0.8910
Total Task Duration, seconds 3.0330
ThreadNoExecuted,
times		Average Speed,
iterations/second		Average Duration,
seconds		Max Duration,
seconds		Min Duration,
seconds		Connect Time,
seconds		Disconnect Time,
seconds		Total Duration,
seconds
11018.5874 0.0538 0.0930 0.0150 0.0160 0.0460 0.5380
21014.7275 0.0679 0.2020 0.0160 0.0150 0.1560 0.6790
31019.7628 0.0506 0.1080 0.0000 0.0160 0.0000 0.5060
41015.4560 0.0647 0.1870 0.0150 0.0160 0.0620 0.6470
51015.0830 0.0663 0.1870 0.0310 0.0160 0.0000 0.6630