General Comments/Executive Summary:

DbSizr demo test

Test Results: The following table shows the various operations that were performed against the test target. Each operation is an atomic measure which represents a unit of work. The first column of the table shows the type of operation that was performed, and the rest of the table shows statistical data associated with that operation. The table shows the total number of operations, Response Time and Throughput data. Here are some simple definitions of Response Time and Throughput. Response Time is the end to end elapsed time for an operation to complete, and Throughput is the number of operations that could be performed per unit of time. Response time is a good indicator of how FAST a server (or Test Target) is from a end user perspective, while Throughput is an indicator of the volume of work that can be performed simultaneously by the server. Both of these metrics are important. The following table also shows the variability of Response Times during the experiment using Standard Deviation about the mean, along with a presentation of data points which show operations which took the least Response Time (Min), the most time (Max) and the time taken by the last operation (Last).

Completion Time Summary This section shows the breakdown in response times for this test. The time intervals specified are defined as part of test setup. This section readily shows how different Quality Of Service (QOS) criteria were met under these simulation conditions. This data can also be used to understand the response time that you may see in a production environment under load conditions simulated by this test.

Number of Requests completed within 50000 millisecs : 1470
Number of Requests completed within 45000 millisecs : 1470
Number of Requests completed within 40000 millisecs : 1470
Number of Requests completed within 35000 millisecs : 1470
Number of Requests completed within 30000 millisecs : 1470

Test Characteristics Following are some basic run-time summaries of this simulation. This shows the amount of time spent during different stages of the test. It also presents an overall count of the number of test errors that were encountered during the test.

Test WarmUp Time : 0.09 Secs.
Test RampUp Time : 9.57 Secs.
Test Steady State : 148.71 Secs.
Test RampDown Time : 0.00 Secs.
Error Count: 0

Test Configuration Summary This section documents the number of users simulated (or specified to simulate), a summary of test settings that were configured using test setup, Acceptance criteria definitions, script file(s) used for the test, server configuration details.

Simultaneous User Sessions = 10

Test Settings file This Documents the settings file (SIZR.INI). To reproduce these settings, you can simply cut this part of the report and paste it into (as) the SIZR.INI file.

This Simulator instance is a Standalone Workload generator
DbResourceName testdb
ResultDataLogOnly 0
ScreenFileName DBSIZR
NoOfDataColumns 15
LogToSeparateFiles 0
StartStats 0
EndStats 0
IgnoreErrors 1
WaitUntilRampup 0
IgnorePauses 0
SeparateScripts 0
StatsStartTime 0
StatsEndTime 0
ScriptAssign 0
StopMode 0
Assignfile ASSIGN.TXT
scriptContainer RANDSCR.TXT
ScriptPrefix USER_
Desynch 1
enableRunFor 0
rateDef 0
ulimit 40
llimit 20
runFor 1200
Timeout 3600000

Acceptance Criteria Definitions: These are definition of Acceptance criteria that were part of test setup.

99.00% of Ops have to complete with Latency Less Than 50000 MilliSeconds
95.00% of Ops have to complete with Latency Less Than 45000 MilliSeconds
90.00% of Ops have to complete with Latency Less Than 40000 MilliSeconds
85.00% of Ops have to complete with Latency Less Than 35000 MilliSeconds
80.00% of Ops have to complete with Latency Less Than 30000 MilliSeconds

ScriptFile used for Test

! DbSizr Sample Script
! Copyright 1998 by Technovations
Inc
! Lexington MA 02420
! http://www.technovations.com
! Sales Inquiries : sales@technovations.com
!
! First
let's desynchronize the users by using random waits

pause 1 2

! This is a special DbSizr keyword which specifies that the
! test should run for 200 iterations. Note that the RUNFOR
! Command overrides the REWIND command.

REWIND 200


! This is a DbSizr Command which allows the session/user to pause
! randomly anywhere between 0 and 7 seconds.

pause 0 7

! The Open command opens the default DataResource. Note that the
! Open Command can also be overloaded to open a different
! DataResource than the default.

open

! Pause again

pause 1 3
! The folowing lines contain plain SQL which will be used by
! DbSizr to develop the load for the sample test. These assume that
! the table called credentials table exists. We assume that you have
! started this exercise by first executing the setup script.


INSERT INTO credentialsTable VALUES ('Joe Schmoe'
'secret'
'12345678'
'false'
'ApplePicker')

select id from credentialsTable where username = 'Joe Schmoe'
insert into credentialsTable values('Larry'
'Jones'
'345'
'false'
'ApplePicker')

INSERT INTO credentialsTable VALUES ('Ramthirth Ganguly'
'gangster'
'1001'
'false'
'')
INSERT INTO credentialsTable VALUES ('TEST ACCOUNT'
'TESTING123'
'1002'
'false'
'')
pause 1 5
INSERT INTO credentialsTable VALUES ('STEVE DONAHUE'
'THEDON'
'1003'
'false'
'')
INSERT INTO credentialsTable VALUES ('Larry+Jones'
'RK'
'1004'
'false'
'')

! Pause again

pause 1 5
update credentialsTable set username = 'Jones' where password = 'Jones'

!delete from credentialsTable where username = 'Jones'

delete from credentialsTable

! The following command is DbSizr specific and closes the connection
! to the DataResource. Note that all the SQL commands were executed by
! keeping the database connection open. You can choose to intersperse the
! OPEN and CLOSE calls to customize your workload.

close

User Credentials This section contains the usernames and passwords used for this test. Hint - You can cut and paste this entire section into the credentials file to use these settings for future tests.

User_1 sa password
User_2 sa password
User_3 sa password
User_4 sa password
User_5 sa password
User_6 sa password
User_7 sa password
User_8 sa password
User_9 sa password
User_10 sa password

Logfile from Test This section documents the logfile from the test. This logfile has details of every operation that was performed during this experiment. These details can be used to analyze the data to any level of detail or simply to produce scatter graphs by importing to a standard spreadsheet program.

! DbSizr Pro

! Copyright 1997-2000 by Technovations Inc

! http://www.Technovations.com

New test started at 02:12:56 on 10/21/00

Time:1652 USER#:9 RT:1131ms OP:PAU

Time:1863 USER#:10 RT:1863ms OP:PAU

Time:156164 USER#:4 RT:0ms OP:Insert dbRName:testdb Query:INSERT INTO credentialsTable VALUES ('Ramthirth Ganguly' 'gangster' '1001' 'false' '')

Time:156174 USER#:4 RT:10ms OP:Insert dbRName:testdb Query:INSERT INTO credentialsTable VALUES ('TEST ACCOUNT' 'TESTING123' '1002' 'false' '')

Time:156235 USER#:9 RT:1613ms OP:PAU

Time:156235 USER#:9 RT:0ms OP:Update dbRName:testdb Query:update credentialsTable set username = 'Jones' where password = 'Jones'

Time:156255 USER#:9 RT:20ms OP:Delete dbRName:testdb Query:delete from credentialsTable

Time:156255 USER#:9 RT:0ms OP:Close dbRName:testdb Command:close

Time:156555 USER#:2 RT:1392ms OP:PAU

Time:156555 USER#:2 RT:0ms OP:Insert dbRName:testdb Query:INSERT INTO credentialsTable VALUES ('Joe Schmoe' 'secret' '12345678' 'false' 'ApplePicker')

Time:156555 USER#:2 RT:0ms OP:Select dbRName:testdb Query:select id from credentialsTable where username = 'Joe Schmoe'

Time:156565 USER#:2 RT:10ms OP:Insert dbRName:testdb Query:insert into credentialsTable values('Larry' 'Jones' '345' 'false' 'ApplePicker')

Time:156575 USER#:2 RT:10ms OP:Insert dbRName:testdb Query:INSERT INTO credentialsTable VALUES ('Ramthirth Ganguly' 'gangster' '1001' 'false' '')

Time:156575 USER#:2 RT:0ms OP:Insert dbRName:testdb Query:INSERT INTO credentialsTable VALUES ('TEST ACCOUNT' 'TESTING123' '1002' 'false' '')

Time:156595 USER#:9 RT:340ms OP:PAU

Time:156615 USER#:9 RT:10ms OP:Open dbRName:testdb Command:open

Time:157016 USER#:8 RT:2244ms OP:PAU

Time:157016 USER#:8 RT:0ms OP:Insert dbRName:testdb Query:INSERT INTO credentialsTable VALUES ('Joe Schmoe' 'secret' '12345678' 'false' 'ApplePicker')

Time:157016 USER#:8 RT:0ms OP:Select dbRName:testdb Query:select id from credentialsTable where username = 'Joe Schmoe'

Time:157026 USER#:8 RT:10ms OP:Insert dbRName:testdb Query:insert into credentialsTable values('Larry' 'Jones' '345' 'false' 'ApplePicker')

Time:157026 USER#:8 RT:0ms OP:Insert dbRName:testdb Query:INSERT INTO credentialsTable VALUES ('Ramthirth Ganguly' 'gangster' '1001' 'false' '')

Time:157026 USER#:8 RT:0ms OP:Insert dbRName:testdb Query:INSERT INTO credentialsTable VALUES ('TEST ACCOUNT' 'TESTING123' '1002' 'false' '')

Time:157116 USER#:3 RT:2534ms OP:PAU

Time:157116 USER#:3 RT:0ms OP:Insert dbRName:testdb Query:INSERT INTO credentialsTable VALUES ('Joe Schmoe' 'secret' '12345678' 'false' 'ApplePicker')

Time:157116 USER#:3 RT:0ms OP:Select dbRName:testdb Query:select id from credentialsTable where username = 'Joe Schmoe'

Time:157126 USER#:3 RT:10ms OP:Insert dbRName:testdb Query:insert into credentialsTable values('Larry' 'Jones' '345' 'false' 'ApplePicker')

Time:157126 USER#:3 RT:0ms OP:Insert dbRName:testdb Query:INSERT INTO credentialsTable VALUES ('Ramthirth Ganguly' 'gangster' '1001' 'false' '')

Time:157136 USER#:3 RT:10ms OP:Insert dbRName:testdb Query:INSERT INTO credentialsTable VALUES ('TEST ACCOUNT' 'TESTING123' '1002' 'false' '')

Time:157416 USER#:10 RT:2904ms OP:PAU

Time:157566 USER#:7 RT:6990ms OP:PAU

Time:157596 USER#:5 RT:2593ms OP:PAU

Time:157977 USER#:1 RT:3124ms OP:PAU

Test ended at 02:15:35 on 10/21/00

ErrorLog from Test This section logs any and all errors encountered during the test. Many of these errors are application specific and should be self explanatory.

DbSizr was stopped prematurely during this test.

You have chosen hard Termination as your
default stop mode.