07-20-2015 10:32:57:524 : *********** TestIO Utility version 1.4 **********************
07-20-2015 10:32:57:555 : Number of java threads	: 10
07-20-2015 10:32:58:148 : Database Type    : SqlServer
07-20-2015 10:32:58:148 : Host Name        : torperf4
07-20-2015 10:32:58:164 : Port             : 1433
07-20-2015 10:32:58:164 : Database Name    : cmx_ors
07-20-2015 10:32:58:164 : User Name        : cmx_ors
07-20-2015 10:32:58:164 : Password         : ********** 
07-20-2015 10:32:58:164 : JDBC Url generated : jdbc:sqlserver://torperf4:1433;databaseName=cmx_ors;user=cmx_ors;password=!!cmx!!
07-20-2015 10:32:58:164 : Number of records: 60000000
07-20-2015 10:32:58:164 : *************************************************************
07-20-2015 10:32:58:164 : before 10 JDBC connections ....
07-20-2015 10:32:59:396 : after 10 JDBC connrections ....
07-20-2015 10:32:59:412 : JDBC driver version is: 4.0.2206.100
07-20-2015 10:32:59:412 : Temp Table name - c_repos_test_1148
07-20-2015 10:32:59:412 : DML operations are going to be run in multiple threads with thread count = 10
07-20-2015 10:32:59:412 : Start create table and indexes
07-20-2015 10:32:59:412 : CREATE TABLE c_repos_test_1148 ( id int NOT NULL, create_date date, last_update_date date, column1 varchar(255), column2 varchar(255), column3 varchar(255), column4 varchar(255), column5 varchar(255), column6 varchar(255), column7 varchar(255), column8 varchar(255), column9 varchar(255), column10 varchar(255), column11 varchar(255), column12 varchar(255), column13 varchar(255), column14 varchar(255), column15 varchar(255), column16 varchar(255), column17 varchar(255), column18 varchar(255), column19 varchar(255), column20 varchar(255), column21 varchar(255), column22 varchar(255), CONSTRAINT [PK_c_repos_test_1148] PRIMARY KEY CLUSTERED (id))
07-20-2015 10:32:59:427 : CREATE INDEX c_repos_test_1148_index1 on c_repos_test_1148(column1)
07-20-2015 10:32:59:427 : CREATE INDEX c_repos_test_1148_index2 on c_repos_test_1148(column2, column3, column4)
07-20-2015 10:32:59:427 : Done create table and indexes
07-20-2015 10:32:59:427 : Inserting rows in threads begin....
07-20-2015 10:32:59:443 : Start insert rows through thread number 0
07-20-2015 10:32:59:443 : Start insert rows through thread number 1
07-20-2015 10:32:59:443 : Start insert rows through thread number 2
07-20-2015 10:32:59:443 : Start insert rows through thread number 3
07-20-2015 10:32:59:443 : Start insert rows through thread number 4
07-20-2015 10:32:59:443 : Start insert rows through thread number 5
07-20-2015 10:32:59:443 : Start insert rows through thread number 6
07-20-2015 10:32:59:443 : Start insert rows through thread number 7
07-20-2015 10:32:59:443 : Start insert rows through thread number 8
07-20-2015 10:32:59:443 : Start insert rows through thread number 9
07-20-2015 11:30:55:815 : Done insert rows through thread number 6
07-20-2015 11:31:14:364 : Done insert rows through thread number 9
07-20-2015 11:31:41:882 : Done insert rows through thread number 7
07-20-2015 11:31:52:849 : Done insert rows through thread number 8
07-20-2015 11:31:57:654 : Done insert rows through thread number 0
07-20-2015 11:32:03:800 : Done insert rows through thread number 2
07-20-2015 11:32:08:730 : Done insert rows through thread number 3
07-20-2015 11:32:41:115 : Done insert rows through thread number 4
07-20-2015 11:32:51:833 : Done insert rows through thread number 5
07-20-2015 11:33:15:514 : Done insert rows through thread number 1
07-20-2015 11:33:15:514 : Inserting rows in threads end....
07-20-2015 11:33:15:514 : Updating rows in threads begin....
07-20-2015 11:33:15:514 : Start update rows for non-indexed columns through thread number 0
07-20-2015 11:33:15:514 : Start update rows for non-indexed columns through thread number 1
07-20-2015 11:33:15:514 : Start update rows for non-indexed columns through thread number 2
07-20-2015 11:33:15:514 : Start update rows for non-indexed columns through thread number 3
07-20-2015 11:33:15:514 : Start update rows for non-indexed columns through thread number 4
07-20-2015 11:33:15:514 : Start update rows for non-indexed columns through thread number 5
07-20-2015 11:33:15:514 : Start update rows for non-indexed columns through thread number 6
07-20-2015 11:33:15:514 : Start update rows for non-indexed columns through thread number 7
07-20-2015 11:33:15:514 : Start update rows for non-indexed columns through thread number 8
07-20-2015 11:33:15:514 : Start update rows for non-indexed columns through thread number 9
07-20-2015 11:33:26:683 : Done update rows through thread number 6
07-20-2015 11:33:26:714 : Done update rows through thread number 0
07-20-2015 11:33:26:746 : Done update rows through thread number 1
07-20-2015 11:33:26:792 : Done update rows through thread number 7
07-20-2015 11:33:26:808 : Done update rows through thread number 4
07-20-2015 11:33:26:995 : Done update rows through thread number 5
07-20-2015 11:33:27:073 : Done update rows through thread number 2
07-20-2015 11:33:27:104 : Done update rows through thread number 9
07-20-2015 11:33:27:120 : Done update rows through thread number 8
07-20-2015 11:33:27:136 : Done update rows through thread number 3
07-20-2015 11:33:27:136 : Updating rows in threads end....
07-20-2015 11:33:27:136 : Updating rows in threads begin....
07-20-2015 11:33:27:136 : Start update rows for indexed columns through thread number 0
07-20-2015 11:33:27:136 : Start update rows for indexed columns through thread number 1
07-20-2015 11:33:27:136 : Start update rows for indexed columns through thread number 2
07-20-2015 11:33:27:136 : Start update rows for indexed columns through thread number 3
07-20-2015 11:33:27:136 : Start update rows for indexed columns through thread number 4
07-20-2015 11:33:27:136 : Start update rows for indexed columns through thread number 5
07-20-2015 11:33:27:136 : Start update rows for indexed columns through thread number 6
07-20-2015 11:33:27:136 : Start update rows for indexed columns through thread number 7
07-20-2015 11:33:27:136 : Start update rows for indexed columns through thread number 8
07-20-2015 11:33:27:136 : Start update rows for indexed columns through thread number 9
07-20-2015 11:33:45:044 : Done update rows through thread number 9
07-20-2015 11:33:45:138 : Done update rows through thread number 6
07-20-2015 11:33:45:216 : Done update rows through thread number 2
07-20-2015 11:33:45:216 : Done update rows through thread number 0
07-20-2015 11:33:45:216 : Done update rows through thread number 3
07-20-2015 11:33:45:263 : Done update rows through thread number 7
07-20-2015 11:33:45:310 : Done update rows through thread number 4
07-20-2015 11:33:45:341 : Done update rows through thread number 8
07-20-2015 11:33:45:356 : Done update rows through thread number 5
07-20-2015 11:33:45:481 : Done update rows through thread number 1
07-20-2015 11:33:45:481 : Updating rows in threads end....
07-20-2015 11:33:45:481 : Selecting rows in threads begin....
07-20-2015 11:33:45:481 : Start select rows through thread number 0
07-20-2015 11:33:45:481 : Start select rows through thread number 1
07-20-2015 11:33:45:481 : Start select rows through thread number 2
07-20-2015 11:33:45:481 : Start select rows through thread number 3
07-20-2015 11:33:45:481 : Start select rows through thread number 4
07-20-2015 11:33:45:481 : Start select rows through thread number 5
07-20-2015 11:33:45:481 : Start select rows through thread number 6
07-20-2015 11:33:45:481 : Start select rows through thread number 7
07-20-2015 11:33:45:481 : Start select rows through thread number 8
07-20-2015 11:33:45:481 : Start select rows through thread number 9
07-20-2015 11:33:57:431 : Done select rows through thread number 5
07-20-2015 11:33:57:696 : Done select rows through thread number 6
07-20-2015 11:33:57:712 : Done select rows through thread number 0
07-20-2015 11:33:57:743 : Done select rows through thread number 2
07-20-2015 11:33:57:758 : Done select rows through thread number 8
07-20-2015 11:33:57:774 : Done select rows through thread number 9
07-20-2015 11:33:57:774 : Done select rows through thread number 4
07-20-2015 11:33:57:852 : Done select rows through thread number 7
07-20-2015 11:33:57:899 : Done select rows through thread number 1
07-20-2015 11:33:57:930 : Done select rows through thread number 3
07-20-2015 11:33:57:930 : Selecting rows in threads end....
07-20-2015 11:33:57:930 : Deleting rows in threads begin....
07-20-2015 11:33:57:930 : Start delete rows through thread number 0
07-20-2015 11:33:57:930 : Start delete rows through thread number 1
07-20-2015 11:33:57:930 : Start delete rows through thread number 2
07-20-2015 11:33:57:930 : Start delete rows through thread number 3
07-20-2015 11:33:57:930 : Start delete rows through thread number 4
07-20-2015 11:33:57:930 : Start delete rows through thread number 5
07-20-2015 11:33:57:930 : Start delete rows through thread number 6
07-20-2015 11:33:57:930 : Start delete rows through thread number 7
07-20-2015 11:33:57:930 : Start delete rows through thread number 8
07-20-2015 11:33:57:930 : Start delete rows through thread number 9
07-20-2015 11:34:09:412 : Done delete rows through thread number 0
07-20-2015 11:34:09:412 : Done delete rows through thread number 1
07-20-2015 11:34:09:474 : Done delete rows through thread number 7
07-20-2015 11:34:09:646 : Done delete rows through thread number 6
07-20-2015 11:34:09:708 : Done delete rows through thread number 9
07-20-2015 11:34:09:724 : Done delete rows through thread number 4
07-20-2015 11:34:09:817 : Done delete rows through thread number 2
07-20-2015 11:34:09:848 : Done delete rows through thread number 8
07-20-2015 11:34:10:379 : Done delete rows through thread number 5
07-20-2015 11:34:11:268 : Done delete rows through thread number 3
07-20-2015 11:34:11:268 : Deleting rows in threads end....
07-20-2015 11:34:11:268 : Temp Table2 name - c_repos_test_9279
07-20-2015 11:34:11:268 : Start create table as select and indexes
07-20-2015 11:34:11:268 : SELECT * INTO c_repos_test_9279 from c_repos_test_1148
07-20-2015 11:37:14:958 : ALTER TABLE c_repos_test_9279 ADD CONSTRAINT c_repos_test_9279_id UNIQUE (id)
07-20-2015 11:37:28:733 : CREATE INDEX c_repos_test_9279_index1 on c_repos_test_9279(column1)
07-20-2015 11:37:50:807 : CREATE INDEX c_repos_test_9279_index2 on c_repos_test_9279(column2, column3, column4)
07-20-2015 11:38:15:034 : Done create table as select and indexes
07-20-2015 11:38:15:034 : Start drop table c_repos_test_1148
07-20-2015 11:38:15:143 : Done drop table c_repos_test_1148
07-20-2015 11:38:15:143 : Start drop table c_repos_test_9279
07-20-2015 11:38:15:159 : Done drop table c_repos_test_9279
07-20-2015 11:38:15:159 : ************************** Summary **************************
07-20-2015 11:38:15:159 : All DML operations ran in multiple threads with thread count = 10
07-20-2015 11:38:15:159 : All the timings are in hour:min:second:millisecond
07-20-2015 11:38:15:159 : Total distinct database interactions: 9
07-20-2015 11:38:15:159 : 0- operation type: CREATE, count:1
07-20-2015 11:38:15:159 : 1- operation type: INSERT, count:60000001
07-20-2015 11:38:15:159 : 2- operation type: UPDATE, count:200000
07-20-2015 11:38:15:159 : 3- operation type: UPDATE_INDEX, count:200000
07-20-2015 11:38:15:159 : 4- operation type: SELECT, count:200000
07-20-2015 11:38:15:159 : 5- operation type: DELETE, count:200000
07-20-2015 11:38:15:159 : 6- operation type: CTAS, count:1
07-20-2015 11:38:15:159 : 7- operation type: DROP, count:1
07-20-2015 11:38:15:159 : 8- operation type: DROP, count:1
07-20-2015 11:38:15:159 : Total time for the test: 1:5:15:747.0
07-20-2015 11:38:15:159 : Number of operations: 60800005
07-20-2015 11:38:15:159 : Average time for all operations: 0:0:0:0.06440372825627234
07-20-2015 11:38:15:159 : Average transactions/second for all operations: 15527
07-20-2015 11:38:15:159 : 
07-20-2015 11:38:15:159 : Number of create operations: 1
07-20-2015 11:38:15:159 : Total time for create operations: 0:0:0:15.0
07-20-2015 11:38:15:159 : Average time for all create operations: 0:0:0:15.0
07-20-2015 11:38:15:159 : Average transactions/second for all create operations: 66
07-20-2015 11:38:15:159 : 
07-20-2015 11:38:15:159 : Number of create table as select operations: 1
07-20-2015 11:38:15:159 : Total time for create table as select operations: 0:4:3:766.0
07-20-2015 11:38:15:159 : Average time for all create table as select operations: 0:4:3:766.0
07-20-2015 11:38:15:159 : Average transactions/second for all create table as select operations: 0
07-20-2015 11:38:15:159 : 
07-20-2015 11:38:15:159 : Number of drop operations: 2
07-20-2015 11:38:15:159 : Total time for drop operations: 0:0:0:125.0
07-20-2015 11:38:15:159 : Average time for all drop operations: 0:0:0:62.5
07-20-2015 11:38:15:159 : Average transactions/second for all drop operations: 16
07-20-2015 11:38:15:159 : 
07-20-2015 11:38:15:159 : Number of insert operations: 60000001
07-20-2015 11:38:15:159 : Total time for insert operations: 1:0:16:87.0
07-20-2015 11:38:15:159 : Average time for all insert operations: 0:0:0:0.06026811566219807
07-20-2015 11:38:15:159 : Average transactions/second for all insert operations: 16592
07-20-2015 11:38:15:159 : Total bytes of data inserted: 1158196632
07-20-2015 11:38:15:159 : Average bytes of data inserted/second (bytes/second): 320290
07-20-2015 11:38:15:159 : 
07-20-2015 11:38:15:159 : Number of update operations in non-indexed table: 200000
07-20-2015 11:38:15:159 : Total time for update operations in non-indexed table: 0:0:11:622.0
07-20-2015 11:38:15:159 : Average time for all update operations in non-indexed table: 0:0:0:0.05811
07-20-2015 11:38:15:159 : Average transactions/second for all update operations in non-indexed table: 17208
07-20-2015 11:38:15:159 : 
07-20-2015 11:38:15:159 : Number of update operations in indexed table: 200000
07-20-2015 11:38:15:159 : Total time for update operations in indexed table: 0:0:18:345.0
07-20-2015 11:38:15:159 : Average time for all update operations in indexed table: 0:0:0:0.091725
07-20-2015 11:38:15:159 : Average transactions/second for all update operations in indexed table: 10902
07-20-2015 11:38:15:159 : 
07-20-2015 11:38:15:159 : Number of select operations: 200000
07-20-2015 11:38:15:159 : Total time for select operations: 0:0:12:449.0
07-20-2015 11:38:15:159 : Average time for all select operations: 0:0:0:0.062245
07-20-2015 11:38:15:159 : Average transactions/second for all select operations: 16065
07-20-2015 11:38:15:159 : 
07-20-2015 11:38:15:159 : Number of delete operations: 200000
07-20-2015 11:38:15:159 : Total time for delete operations: 0:0:13:338.0
07-20-2015 11:38:15:159 : Average time for all delete operations: 0:0:0:0.06669
07-20-2015 11:38:15:159 : Average transactions/second for all delete operations: 14994
07-20-2015 11:38:15:159 : *************************************************************