home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 11 Util
/
11-Util.zip
/
TRACK.ZIP
/
STATS.SQL
< prev
next >
Wrap
Text File
|
1989-05-17
|
3KB
|
94 lines
/* */
/* This script creates the statistics tables for the Performance Tests */
/* Tracking DB */
/* */
use bench_stat
go
/* */
/* Runs */
/* */
drop table multi_runs
go
create table multi_runs /* Run summary information */
(
multi_number int NOT NULL, /* Queen Run number */
start_time datetime NOT NULL, /* Date/time test started */
end_time datetime NOT NULL, /* Date/time test ended */
startrun int NOT NULL, /* Starting workstation run number */
endrun int NOT NULL, /* Ending workstation run number */
seconds int NOT NULL, /* Number of seconds to run */
users int NOT NULL, /* Number of users */
test_server varchar(30) NOT NULL, /* Name of the server tests run on */
db varchar(30) NOT NULL, /* Database under test */
track_server varchar(30) NOT NULL, /* Performance tracking server name */
max_accts int NOT NULL, /* Max account */
max_teller int NOT NULL, /* Max teller */
max_branch int NOT NULL /* Max branch */
)
go
drop table runs
go
create table runs /* Workstation test information */
(
number int NOT NULL, /* Run number */
computer varchar(30) NOT NULL, /* Computer identifier */
start_time datetime NOT NULL, /* Date/time test started */
end_time datetime NOT NULL, /* Date/time test ended */
iterations int NOT NULL, /* Number of iterations completed */
errors int NOT NULL, /* Number of errors occured */
tot_exec int NOT NULL, /* Total execution time */
min_exec int NOT NULL, /* Minimum execution time */
max_exec int NOT NULL, /* Maximum execution time */
avg_exec float NOT NULL, /* Average execution time */
under1_exec int NOT NULL, /* Number of iterations under 1 sec */
under2_exec int NOT NULL /* Number of iterations under 2 secs */
)
create unique clustered index multi_run_idx on multi_runs(multi_number)
go
create unique clustered index run_idx on runs(number)
go
/* */
/* Multiresults */
/* */
drop table multi_results
go
create table multi_results
(
multi_number int NOT NULL, /* Queen run number */
iterations int NOT NULL, /* Number of iterations completed */
errors int NOT NULL, /* Number of errors occured */
tot_exec int NOT NULL, /* Total execution time */
min_exec int NOT NULL, /* Minimum execution time */
max_exec int NOT NULL, /* Maximum execution time */
avg_exec float NOT NULL, /* Average execution time */
elapsed int NOT NULL, /* Actual elapsed time */
under1_exec int NOT NULL, /* Number of iterations under 1 sec */
under2_exec int NOT NULL /* Number of iterations under 2 secs */
)
go
create unique clustered index multi_results_idx on multi_results(multi_number)
go
/* */
/* Stored procedure to clear all the above tables */
/* */
drop procedure tp_clearstats
go
create procedure tp_clearstats as
truncate table runs
truncate table multi_runs
truncate table multi_results
go