Tests

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_DOC DOC_ID
XQD_1000_3300 XQD_1000_3300_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_1200_2000 XQD_1200_2000_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID

Performance reports

Performance in TOTAL:

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END
*** OVERALL *** for 180 minutes: 85.28 196147 15351 2016-08-31 23:33 2016-09-01 02:33
customer order: creation 12.92 290 2313 2016-08-31 23:33 2016-09-01 02:33
customer order: refuse 0.92 37 164 2016-08-31 23:33 2016-09-01 02:33
order to supplier: creation 3.34 5895 598 2016-08-31 23:33 2016-09-01 02:33
order to supplier: removal 0.04 211165 5 2016-08-31 23:33 2016-09-01 02:33
invoice (draft): creation 3.37 2124 604 2016-08-31 23:33 2016-09-01 02:33
invoice (draft): removal 0.32 61 42 2016-08-31 23:33 2016-09-01 02:33
invoice accept: apply 0.38 2734672 67 2016-08-31 23:33 2016-09-01 02:33
invoice accept: cancel 0.04 643382 8 2016-08-31 23:33 2016-09-01 02:33
customer reserve: creation 46.30 42535 8288 2016-08-31 23:33 2016-09-01 02:33
customer reserve: removal 1.16 79625 208 2016-08-31 23:33 2016-09-01 02:33
realization accept: apply 5.78 74 1034 2016-08-31 23:33 2016-09-01 02:33
realization accept: cancel 0.97 45 171 2016-08-31 23:33 2016-09-01 02:33
payment from customer: creation 4.38 199 780 2016-08-31 23:33 2016-09-01 02:33
payment from customer: removal 0.39 20 68 2016-08-31 23:33 2016-09-01 02:33
payment to supplier: creation 3.47 883 622 2016-08-31 23:33 2016-09-01 02:33
payment to supplier: removal 0.26 21 45 2016-08-31 23:33 2016-09-01 02:33
service: total inventory turnovers 0.91 4465 163 2016-08-31 23:33 2016-09-01 02:33
service: total monetary turnovers 0.93 10 162 2016-08-31 23:33 2016-09-01 02:33
service: refresh index statistics 0.06 1286 9 2016-08-31 23:33 2016-09-01 02:33
Done for 4460 ms, from 2:37:35.76 to 2:37:40.22.

Performance in DYNAMIC:

ACTION ITRV_NO CNT_OK_PER_MINUTE CNT_ALL CNT_OK CNT_ERR ERR_PRC ITRV_BEG ITRV_END
interval # 1, overall 1 270 5371 4865 506 9.42 23:33:05 23:51:02
interval # 2, overall 2 105 2008 1882 126 6.27 23:51:03 00:09:00
interval # 3, overall 3 80 1419 1368 51 3.59 00:09:01 00:26:58
interval # 4, overall 4 71 1330 1282 48 3.61 00:26:59 00:44:56
interval # 5, overall 5 78 1496 1407 89 5.95 00:44:57 01:02:54
interval # 6, overall 6 58 1183 1040 143 12.09 01:02:55 01:20:52
interval # 7, overall 7 62 1235 1110 125 10.12 01:20:53 01:38:50
interval # 8, overall 8 47 992 840 152 15.32 01:38:51 01:56:48
interval # 9, overall 9 50 960 907 53 5.52 01:56:49 02:14:46
interval # 10, overall 10 36 690 650 40 5.80 02:14:47 02:32:44
Done for 4780 ms, from 2:37:41.65 to 2:37:46.43.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED DISTINCT_ATTACHMENTS
WARM_TIME 1 1590.46 0.6865 1.4392 898 96
WARM_TIME 2 1679.14 0.6818 1.2494 678 80
WARM_TIME 3 1557.46 0.8982 1.1692 475 74
WARM_TIME 4 1416.27 0.9645 1.0276 297 61
WARM_TIME 5 1209.97 0.9625 1.0329 331 60
WARM_TIME 6 1071.35 0.9722 1.0317 367 64
WARM_TIME 7 978.41 0.9699 1.0298 400 59
WARM_TIME 8 910.93 0.9679 1.0317 515 60
WARM_TIME 9 864.73 0.9662 1.0342 575 55
WARM_TIME 10 832.42 0.9670 1.0326 609 51
TEST_TIME 11 813.75 0.9603 1.0398 799 37
TEST_TIME 12 807.01 0.9612 1.0380 821 29
TEST_TIME 13 790.72 0.9780 1.0202 470 16
TEST_TIME 14 761.89 0.9833 1.0111 224 8
TEST_TIME 15 722.21 0.9956 1.0052 104 3
TEST_TIME 16 689.61 0.9876 1.0097 180 4
TEST_TIME 17 655.65 0.9996 1.0004 11 2
TEST_TIME 18 620.29 0.9988 1.0014 13 3
TEST_TIME 19 589.53 0.9983 1.0015 45 3
TEST_TIME 21 534.40 0.9997 1.0003 8 1
TEST_TIME 22 511.78 0.9987 1.0012 30 1
TEST_TIME 23 492.45 0.9975 1.0025 65 2
TEST_TIME 24 474.75 0.9967 1.0033 30 3
TEST_TIME 25 458.22 0.9980 1.0010 14 2
TEST_TIME 26 441.61 0.9987 1.0013 32 1
TEST_TIME 27 427.33 0.9997 1.0002 8 2
TEST_TIME 28 416.07 0.9933 1.0049 91 4
TEST_TIME 29 404.22 0.9988 1.0012 33 1
TEST_TIME 30 393.19 0.9976 1.0020 40 2
TEST_TIME 37 322.72 0.9933 1.0037 79 2
TEST_TIME 39 310.52 0.9897 1.0100 275 3
TEST_TIME 40 307.71 0.9938 1.0048 90 3
TEST_TIME 41 302.77 0.9963 1.0056 74 3
TEST_TIME 43 291.68 0.9954 1.0060 78 2
TEST_TIME 44 286.96 0.9993 1.0006 18 1
TEST_TIME 46 274.99 0.9989 1.0011 30 2
TEST_TIME 47 269.48 0.9999 1.0001 3 1
TEST_TIME 48 265.45 0.9998 1.0001 5 1
TEST_TIME 49 262.56 0.9906 1.0057 123 3
TEST_TIME 50 261.32 0.9904 1.0134 85 3
TEST_TIME 53 250.05 0.9992 1.0007 12 2
TEST_TIME 54 247.07 0.9999 1.0001 5 1
TEST_TIME 55 242.73 0.9995 1.0005 17 1
TEST_TIME 59 226.72 0.9986 1.0013 38 1
TEST_TIME 60 223.31 0.9997 1.0002 8 1
TEST_TIME 62 216.38 0.9993 1.0006 21 1
TEST_TIME 63 213.70 0.9971 1.0024 48 3
TEST_TIME 64 213.13 0.9894 1.0026 49 2
TEST_TIME 70 195.72 0.9999 1.0001 6 1
TEST_TIME 72 193.46 0.9865 1.0056 39 3
TEST_TIME 73 194.57 0.9863 1.0048 137 4
TEST_TIME 74 193.18 0.9984 1.0017 52 3
TEST_TIME 77 187.52 0.9979 1.0022 67 2
TEST_TIME 78 186.61 0.9943 1.0028 38 2
TEST_TIME 79 184.99 0.9988 1.0011 37 2
TEST_TIME 83 176.93 0.9980 1.0019 64 1
TEST_TIME 86 171.46 1.0000 1.0000 1 1
TEST_TIME 87 171.01 0.9978 1.0022 74 4
TEST_TIME 88 169.81 0.9978 1.0020 68 4
TEST_TIME 89 168.51 0.9984 1.0015 50 2
TEST_TIME 90 167.71 0.9952 1.0063 21 3
TEST_TIME 91 168.69 0.9895 1.0061 169 3
TEST_TIME 92 168.10 0.9988 1.0013 48 2
TEST_TIME 94 166.28 0.9990 1.0010 38 1
TEST_TIME 100 157.32 0.9989 1.0012 39 2
TEST_TIME 101 157.65 0.9995 1.0005 16 1
TEST_TIME 102 156.22 0.9998 1.0002 9 1
TEST_TIME 105 153.62 0.9962 1.0033 64 2
TEST_TIME 106 153.01 0.9978 1.0021 77 2
TEST_TIME 107 154.82 0.9812 1.0150 117 4
TEST_TIME 108 155.71 1.0000 1.0000 2 1
TEST_TIME 114 147.87 0.9997 1.0003 10 1
TEST_TIME 115 146.64 1.0000 1.0000 1 1
TEST_TIME 120 142.46 0.9998 1.0002 7 1
TEST_TIME 121 141.74 0.9998 1.0001 6 1
TEST_TIME 122 142.14 0.9997 1.0002 10 1
TEST_TIME 126 140.36 0.9808 1.0079 93 4
TEST_TIME 127 141.10 0.9948 1.0071 173 4
TEST_TIME 128 141.06 0.9995 1.0004 17 2
TEST_TIME 129 140.26 0.9983 1.0017 68 1
TEST_TIME 130 139.43 1.0000 1.0000 2 1
TEST_TIME 131 138.40 0.9998 1.0002 9 1
TEST_TIME 133 137.85 0.9993 1.0007 27 1
TEST_TIME 134 139.01 0.9925 1.0068 39 3
TEST_TIME 135 139.51 0.9958 1.0101 107 3
TEST_TIME 136 139.99 0.9993 1.0007 29 3
TEST_TIME 137 139.09 0.9999 1.0002 9 1
TEST_TIME 139 137.83 0.9994 1.0005 23 1
TEST_TIME 140 137.68 0.9945 1.0046 11 2
TEST_TIME 142 138.29 0.9984 1.0017 75 4
TEST_TIME 143 137.67 0.9992 1.0008 34 2
TEST_TIME 144 137.06 0.9983 1.0010 17 2
TEST_TIME 145 137.51 0.9996 1.0005 20 1
TEST_TIME 146 137.41 0.9944 1.0010 32 2
TEST_TIME 147 136.70 0.9994 1.0006 26 2
TEST_TIME 151 133.22 0.9996 1.0004 18 1
TEST_TIME 152 132.47 0.9995 1.0005 24 1
TEST_TIME 155 130.80 0.9998 1.0001 9 1
TEST_TIME 156 130.85 0.9944 1.0057 50 3
TEST_TIME 157 130.98 0.9983 1.0017 75 2
TEST_TIME 158 130.78 0.9970 1.0091 27 3
TEST_TIME 159 132.66 0.9984 1.0017 48 2
TEST_TIME 160 132.12 0.9995 1.0004 21 1
TEST_TIME 161 132.77 0.9996 1.0003 13 1
TEST_TIME 162 132.22 0.9999 1.0000 4 1
TEST_TIME 163 131.56 0.9989 1.0021 13 2
TEST_TIME 164 132.50 0.9889 1.0032 61 3
TEST_TIME 165 132.15 0.9998 1.0003 12 2
TEST_TIME 167 132.44 0.9907 1.0018 59 2
TEST_TIME 168 132.91 0.9931 1.0033 38 3
TEST_TIME 169 132.95 0.9971 1.0018 74 3
TEST_TIME 170 133.92 0.9998 1.0002 9 1
TEST_TIME 171 133.45 0.9999 1.0000 4 1
TEST_TIME 172 132.74 0.9996 1.0004 21 1
TEST_TIME 178 128.54 0.9991 1.0008 43 1
TEST_TIME 179 128.13 0.9984 1.0009 41 2
TEST_TIME 180 127.63 0.9992 1.0008 41 1
TEST_TIME 181 128.17 0.9911 1.0014 41 2
TEST_TIME 182 127.77 0.9991 1.0010 45 1
TEST_TIME 183 127.51 0.9975 1.0012 47 2
TEST_TIME 184 127.88 0.9929 1.0075 86 5
TEST_TIME 185 128.32 0.9987 1.0012 65 2
TEST_TIME 186 127.80 1.0000 1.0000 3 1
TEST_TIME 188 128.72 0.9984 1.0033 13 2
TEST_TIME 189 129.87 0.9892 1.0124 23 3
TEST_TIME 190 130.86 0.9995 1.0006 100 100
Done for 16990 ms, from 2:37:46.64 to 2:38:03.63.

Performance from TRACE for ISQL instance #1:

TRACED_DATA ITRV_NO SP_CLIENT_ORDER SP_CANCEL_CLIENT_ORDER SP_SUPPLIER_ORDER SP_CANCEL_SUPPLIER_ORDER SP_SUPPLIER_INVOICE SP_CANCEL_SUPPLIER_INVOICE SP_ADD_INVOICE_TO_STOCK SP_CANCEL_ADDING_INVOICE SP_CUSTOMER_RESERVE SP_CANCEL_CUSTOMER_RESERVE SP_RESERVE_WRITE_OFF SP_CANCEL_WRITE_OFF SP_PAY_FROM_CUSTOMER SP_CANCEL_PAY_FROM_CUSTOMER SP_PAY_TO_SUPPLIER SP_CANCEL_PAY_TO_SUPPLIER SRV_MAKE_INVNT_SALDO SRV_MAKE_MONEY_SALDO SRV_RECALC_IDX_STAT ITRV_BEG ITRV_END
fetches per second 9 29111 50941 <null> <null> 54802 <null> 891 <null> 534 <null> 50873 <null> 110301 <null> 176063 <null> <null> <null> <null> 01:56:49 02:14:46
marks per second 9 5559 4176 <null> <null> 3415 <null> 123 <null> 69 <null> 8929 <null> 2518 <null> 5587 <null> <null> <null> <null> 01:56:49 02:14:46
reads/fetches*100 9 4 5 <null> <null> 6 <null> 15 <null> 22 <null> 4 <null> 6 <null> 3 <null> <null> <null> <null> 01:56:49 02:14:46
writes/marks*100 9 13 15 <null> <null> 5 <null> 1 <null> 2 <null> 7 <null> 11 <null> 3 <null> <null> <null> <null> 01:56:49 02:14:46
Done for 5070 ms, from 2:38:04.04 to 2:38:09.11.

Performance in DETAILS:

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL JOB_BEG JOB_END
doc_list_aiud 16749 16080 669 3.99 0 14196 56 669 2016-08-31 23:33 2016-09-01 02:33
doc_list_biud 16779 16077 702 4.18 0 453103 1382 702 2016-08-31 23:33 2016-09-01 02:33
sp_add_invoice_to_stock 513 67 446 86.93 42744 10334347 2734672 446 2016-08-31 23:33 2016-09-01 02:33
sp_cancel_adding_invoice 42 8 34 80.95 4868 2284796 643382 34 2016-08-31 23:33 2016-09-01 02:33
sp_cancel_client_order 180 164 16 8.88 0 499 37 16 2016-08-31 23:33 2016-09-01 02:33
sp_cancel_customer_reserve 656 208 448 68.29 249 453134 79625 448 2016-08-31 23:33 2016-09-01 02:33
sp_cancel_pay_from_customer 69 68 1 1.44 0 203 20 1 2016-08-31 23:33 2016-09-01 02:33
sp_cancel_pay_to_supplier 47 45 2 4.25 0 109 21 2 2016-08-31 23:33 2016-09-01 02:33
sp_cancel_supplier_invoice 72 42 30 41.66 0 250 61 30 2016-08-31 23:33 2016-09-01 02:33
sp_cancel_supplier_order 36 5 31 86.11 109 1053782 211165 31 2016-08-31 23:33 2016-09-01 02:33
sp_cancel_write_off 403 171 232 57.56 0 281 45 232 2016-08-31 23:33 2016-09-01 02:33
sp_client_order 2313 2313 0 0.00 0 6177 290 0 2016-08-31 23:33 2016-09-01 02:33
sp_customer_reserve 8288 8288 0 0.00 842 156328 42535 0 2016-08-31 23:33 2016-09-01 02:33
sp_fill_shopping_cart 3515 3515 0 0.00 0 51013 796 0 2016-08-31 23:33 2016-09-01 02:33
sp_fill_shopping_cart_clo_res 8288 8288 0 0.00 0 47 3 0 2016-08-31 23:33 2016-09-01 02:33
sp_get_clo_for_invoice 69 69 0 0.00 0 125 28 0 2016-08-31 23:33 2016-09-01 02:33
sp_kill_cost_storno 521 293 228 43.76 0 234 9 228 2016-08-31 23:33 2016-09-01 02:33
sp_kill_qstorno_ret_qs2qd 1741 634 1107 63.58 0 453087 26127 1107 2016-08-31 23:33 2016-09-01 02:33
sp_kill_qty_storno 2395 1700 695 29.01 0 453103 13064 695 2016-08-31 23:33 2016-09-01 02:33
sp_lock_selected_doc 2235 1570 665 29.75 0 16 0 665 2016-08-31 23:33 2016-09-01 02:33
sp_make_cost_storno 2505 2505 0 0.00 0 14055 268 0 2016-08-31 23:33 2016-09-01 02:33
sp_multiply_rows_for_pdistr 2505 2505 0 0.00 0 468 24 0 2016-08-31 23:33 2016-09-01 02:33
sp_multiply_rows_for_qdistr 2314 2314 0 0.00 0 5975 247 0 2016-08-31 23:33 2016-09-01 02:33
sp_pay_from_customer 780 780 0 0.00 31 3166 199 0 2016-08-31 23:33 2016-09-01 02:33
sp_pay_to_supplier 622 622 0 0.00 47 14289 883 0 2016-08-31 23:33 2016-09-01 02:33
sp_payment_common 1402 1402 0 0.00 0 422 27 0 2016-08-31 23:33 2016-09-01 02:33
sp_qd_handle_on_cancel_clo 180 164 16 8.88 0 468 18 16 2016-08-31 23:33 2016-09-01 02:33
sp_qd_handle_on_invoice_upd_sts 89 76 13 14.60 109 447674 73833 13 2016-08-31 23:33 2016-09-01 02:33
sp_qd_handle_on_reserve_upd_sts 1034 1034 0 0.00 0 187 14 0 2016-08-31 23:33 2016-09-01 02:33
sp_reserve_write_off 1127 1034 93 8.25 0 1623 74 93 2016-08-31 23:33 2016-09-01 02:33
sp_supplier_invoice 604 604 0 0.00 31 35381 2124 0 2016-08-31 23:33 2016-09-01 02:33
sp_supplier_order 598 598 0 0.00 31 55692 5895 0 2016-08-31 23:33 2016-09-01 02:33
srv_find_qd_qs_mism 8834 8160 674 7.62 0 3495 19 674 2016-08-31 23:33 2016-09-01 02:33
srv_make_invnt_saldo 163 163 0 0.00 1778 9360 4465 0 2016-08-31 23:33 2016-09-01 02:33
srv_make_money_saldo 162 162 0 0.00 0 47 10 0 2016-08-31 23:33 2016-09-01 02:33
srv_recalc_idx_stat 9 9 0 0.00 967 1576 1286 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-abend:sp_add_invoice_to_stock 446 446 0 0.00 0 110 6 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-abend:sp_cancel_adding_invoice 59 59 0 0.00 0 125 21 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-abend:sp_cancel_client_order 16 16 0 0.00 0 110 14 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-abend:sp_cancel_customer_reserve 10 10 0 0.00 0 16 6 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-abend:sp_cancel_pay_from_customer 1 1 0 0.00 0 0 0 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-abend:sp_cancel_pay_to_supplier 2 2 0 0.00 0 0 0 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-abend:sp_cancel_supplier_invoice 30 30 0 0.00 0 31 4 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-abend:sp_cancel_supplier_order 132 132 0 0.00 0 234 35 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-abend:sp_cancel_write_off 4 4 0 0.00 0 0 0 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-abend:sp_reserve_write_off 93 93 0 0.00 0 62 10 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_add_invoice_to_stock 101 101 0 0.00 15 795 179 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_cancel_adding_invoice 8 8 0 0.00 15 483 126 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_cancel_client_order 164 164 0 0.00 0 125 10 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_cancel_customer_reserve 73 73 0 0.00 0 62 8 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_cancel_pay_from_customer 68 68 0 0.00 0 31 4 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_cancel_pay_to_supplier 45 45 0 0.00 0 62 7 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_cancel_supplier_invoice 10 10 0 0.00 0 62 9 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_cancel_supplier_order 5 5 0 0.00 15 156 50 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_cancel_write_off 97 97 0 0.00 0 63 10 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_client_order 2320 2320 0 0.00 0 219 13 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_customer_reserve 86 86 0 0.00 0 63 10 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_pay_from_customer 781 781 0 0.00 0 171 9 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_pay_to_supplier 627 627 0 0.00 0 109 8 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_reserve_write_off 1034 1034 0 0.00 0 187 11 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_supplier_invoice 605 605 0 0.00 0 187 13 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:sp_supplier_order 628 628 0 0.00 0 156 13 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:srv_make_invnt_saldo 164 164 0 0.00 0 31 3 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:srv_make_money_saldo 162 162 0 0.00 0 62 2 0 2016-08-31 23:33 2016-09-01 02:33
t$perf-norm:srv_recalc_idx_stat 9 9 0 0.00 0 16 12 0 2016-08-31 23:33 2016-09-01 02:33
v_add_invoice_to_stock 1026 134 892 86.93 0 31 4 892 2016-08-31 23:33 2016-09-01 02:33
v_all_customers 3436 3436 0 0.00 0 16 0 0 2016-08-31 23:33 2016-09-01 02:33
v_all_suppliers 2404 2404 0 0.00 0 16 0 0 2016-08-31 23:33 2016-09-01 02:33
v_all_wares 4626 4626 0 0.00 0 16 0 0 2016-08-31 23:33 2016-09-01 02:33
v_cancel_adding_invoice 78 14 64 82.05 0 16 4 64 2016-08-31 23:33 2016-09-01 02:33
v_cancel_client_order 360 328 32 8.88 0 16 0 32 2016-08-31 23:33 2016-09-01 02:33
v_cancel_customer_prepayment 138 136 2 1.44 0 16 1 2 2016-08-31 23:33 2016-09-01 02:33
v_cancel_customer_reserve 166 146 20 12.04 0 16 1 20 2016-08-31 23:33 2016-09-01 02:33
v_cancel_payment_to_supplier 94 90 4 4.25 0 16 0 4 2016-08-31 23:33 2016-09-01 02:33
v_cancel_supplier_invoice 80 20 60 75.00 0 16 3 60 2016-08-31 23:33 2016-09-01 02:33
v_cancel_supplier_order 72 10 62 86.11 0 0 0 62 2016-08-31 23:33 2016-09-01 02:33
v_cancel_write_off 202 194 8 3.96 0 16 2 8 2016-08-31 23:33 2016-09-01 02:33
v_max_id_clo_ord 599 599 0 0.00 0 577 42 0 2016-08-31 23:33 2016-09-01 02:33
v_max_id_clo_res 82 82 0 0.00 0 16 2 0 2016-08-31 23:33 2016-09-01 02:33
v_max_id_ord_sup 604 604 0 0.00 0 172 7 0 2016-08-31 23:33 2016-09-01 02:33
v_max_non_paid_invoice 622 622 0 0.00 0 203 7 0 2016-08-31 23:33 2016-09-01 02:33
v_max_non_paid_realizn 780 780 0 0.00 0 32 5 0 2016-08-31 23:33 2016-09-01 02:33
v_min_id_clo_ord 598 598 0 0.00 0 2137 101 0 2016-08-31 23:33 2016-09-01 02:33
v_min_id_clo_res 82 82 0 0.00 0 16 1 0 2016-08-31 23:33 2016-09-01 02:33
v_min_id_ord_sup 604 604 0 0.00 0 951 50 0 2016-08-31 23:33 2016-09-01 02:33
v_min_non_paid_invoice 622 622 0 0.00 0 125 17 0 2016-08-31 23:33 2016-09-01 02:33
v_min_non_paid_realizn 780 780 0 0.00 0 140 12 0 2016-08-31 23:33 2016-09-01 02:33
v_our_firm 1190 1190 0 0.00 0 16 0 0 2016-08-31 23:33 2016-09-01 02:33
v_reserve_write_off 2254 2068 186 8.25 0 16 1 186 2016-08-31 23:33 2016-09-01 02:33
x_lock_depdocs_on_canc_invoice 118 40 78 66.10 0 16 1 78 2016-08-31 23:33 2016-09-01 02:33
x_lock_depdocs_on_canc_sup_ord 36 5 31 86.11 0 0 0 31 2016-08-31 23:33 2016-09-01 02:33
x_make_qstorno_1000_1200 607 607 0 0.00 0 47455 3338 0 2016-08-31 23:33 2016-09-01 02:33
x_make_qstorno_1200_2000 604 604 0 0.00 0 8331 486 0 2016-08-31 23:33 2016-09-01 02:33
x_make_qstorno_2100_3300 8288 8288 0 0.00 842 156312 42516 0 2016-08-31 23:33 2016-09-01 02:33
Done for 23590 ms, from 2:38:11.01 to 2:38:34.60.

Config param. mon_unit_perf=0, data from MON$ tables were NOT gathered.

Exceptions occured during test work:

FB_MNEMONA CNT UNIT FB_GDSCODE DTS_BEG DTS_END
deadlock 4 sp_kill_cost_storno 335544336 2016-08-31 23:34 2016-09-01 01:45
deadlock 3 sp_qd_handle_on_invoice_upd_sts 335544336 2016-09-01 01:31 2016-09-01 01:54
lock_conflict 3 sp_kill_cost_storno 335544345 2016-09-01 00:09 2016-09-01 02:31
lock_conflict 583 sp_lock_selected_doc 335544345 2016-08-31 23:33 2016-09-01 02:32
lock_conflict 16 sp_qd_handle_on_cancel_clo 335544345 2016-08-31 23:33 2016-09-01 01:45
lock_conflict 10 sp_qd_handle_on_invoice_upd_sts 335544345 2016-08-31 23:33 2016-09-01 02:26
lock_conflict 39 x_lock_depdocs_on_canc_invoice 335544345 2016-08-31 23:33 2016-09-01 02:26
lock_conflict 8 x_lock_depdocs_on_canc_sup_ord 335544345 2016-08-31 23:33 2016-09-01 01:38
Done for 2470 ms, from 2:38:35.25 to 2:38:37.72.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP25-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 81643
MON$OLDEST_ACTIVE 81644
MON$OLDEST_SNAPSHOT 81644
MON$NEXT_TRANSACTION 81644
MON$PAGE_BUFFERS 384
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-12-11 10:02:47.3010
MON$PAGES 144884
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.7.27025 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.7.27025 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.7.27025 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.7.27025 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
on disk structure version 11.2

Database statistics, full


Database "D:\OLTP-EMUL\oltp25-small.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 86147
Page size 8192
ODS version 11.2
Oldest transaction 81645
Oldest active 81646
Oldest snapshot 81646
Next transaction 81647
Bumped transaction 1
Sequence number 0
Next attachment ID 4420
Implementation ID 24
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 10:02:47
Attributes force write

Variable header data:
Sweep interval: 0
*END*


Database file sequence:
File D:\OLTP-EMUL\oltp25-small.fdb is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 259, Index root page: 260
Average record length: 34.62, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 32%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_OUR_FIRM (4)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 48
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_SUPPLIER (3)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 13.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_AGENTS (0)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

BUSINESS_OPS (158)
Primary pointer page: 280, Index root page: 281
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BO_UNIT_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BUSINESS_OPS_RND_WGTH (2)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 0.84, total dup: 7, max dup: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RDB$1 (0)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 1.63, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

DOC_DATA (141)
Primary pointer page: 199, Index root page: 200
Average record length: 44.80, total records: 413354
Average version length: 46.13, total versions: 11413, max versions: 1
Data pages: 4431, data page slots: 4431, average fill: 73%
Fill distribution:
0 - 19% = 1
20 - 39% = 24
40 - 59% = 81
60 - 79% = 4286
80 - 99% = 39

Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 1268, nodes: 413354
Average data length: 11.54, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 134
20 - 39% = 44
40 - 59% = 362
60 - 79% = 80
80 - 99% = 648

Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 1222, nodes: 413354
Average data length: 6.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 31
40 - 59% = 1189
60 - 79% = 2
80 - 99% = 0

Index FK_DOC_DATA_DOC_LIST (3)
Depth: 2, leaf buckets: 362, nodes: 413354
Average data length: 0.79, total dup: 361943, max dup: 49
Fill distribution:
0 - 19% = 2
20 - 39% = 25
40 - 59% = 98
60 - 79% = 8
80 - 99% = 229

DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 59.06, total records: 63590
Average version length: 53.17, total versions: 4275, max versions: 4
Data pages: 822, data page slots: 822, average fill: 77%
Fill distribution:
0 - 19% = 3
20 - 39% = 25
40 - 59% = 60
60 - 79% = 298
80 - 99% = 436

Index DOC_LIST_ID_DESC (1)
Depth: 2, leaf buckets: 187, nodes: 63590
Average data length: 6.29, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 17
40 - 59% = 170
60 - 79% = 0
80 - 99% = 0

Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 55, nodes: 63590
Average data length: 0.01, total dup: 63540, max dup: 16154
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 39
60 - 79% = 8
80 - 99% = 8

Index PK_DOC_LIST (0)
Depth: 2, leaf buckets: 119, nodes: 63590
Average data length: 6.29, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 3
20 - 39% = 17
40 - 59% = 28
60 - 79% = 1
80 - 99% = 70

DOC_STATES (153)
Primary pointer page: 257, Index root page: 258
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 13.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_NAME_UNQ (2)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 29.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_DOC_STATES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 1.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

FB_ERRORS (159)
Primary pointer page: 287, Index root page: 288
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 12, data page slots: 12, average fill: 75%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

Index FB_ERRORS_GDS_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 758
Average data length: 1.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

INVNT_SALDO (147)
Primary pointer page: 216, Index root page: 217
Average record length: 62.31, total records: 400
Average version length: 13.41, total versions: 50799, max versions: 155
Data pages: 203, data page slots: 203, average fill: 96%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 202

Index PK_INVNT_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 278, Index root page: 279
Average record length: 0.28, total records: 107525
Average version length: 68.40, total versions: 107091, max versions: 1
Data pages: 1648, data page slots: 1648, average fill: 82%
Fill distribution:
0 - 19% = 3
20 - 39% = 36
40 - 59% = 106
60 - 79% = 297
80 - 99% = 1206

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 3, leaf buckets: 295, nodes: 107525
Average data length: 8.55, total dup: 10495, max dup: 3
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 124
60 - 79% = 131
80 - 99% = 37

MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 14.84, total records: 49
Average version length: 9.00, total versions: 2691, max versions: 229
Data pages: 11, data page slots: 11, average fill: 80%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 9

Index PK_MONEY_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 49
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MONEY_TURNOVER_LOG (142)
Primary pointer page: 206, Index root page: 207
Average record length: 0.17, total records: 5061
Average version length: 44.20, total versions: 5042, max versions: 1
Data pages: 54, data page slots: 54, average fill: 90%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 4
80 - 99% = 49

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 2, leaf buckets: 4, nodes: 5061
Average data length: 0.18, total dup: 4971, max dup: 1060
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 2
80 - 99% = 0

MON_LOG (164)
Primary pointer page: 303, Index root page: 304
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_ROWSET_DESC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG_TABLE_STATS (165)
Primary pointer page: 316, Index root page: 317
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_ROWSET (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG_TABLE_STATS (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

OPTYPES (138)
Primary pointer page: 186, Index root page: 187
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index OPTYPES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 4.56, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_OPTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 2.11, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PDISTR (150)
Primary pointer page: 241, Index root page: 242
Average record length: 25.76, total records: 112056
Average version length: 31.54, total versions: 70755, max versions: 11
Data pages: 1188, data page slots: 1188, average fill: 85%
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 6
60 - 79% = 343
80 - 99% = 835

Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 89, nodes: 112056
Average data length: 0.01, total dup: 112007, max dup: 23245
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 46
60 - 79% = 21
80 - 99% = 20

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 109, nodes: 112056
Average data length: 0.89, total dup: 100790, max dup: 25
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 55
60 - 79% = 31
80 - 99% = 21

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 118, nodes: 112056
Average data length: 0.90, total dup: 100790, max dup: 25
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 75
60 - 79% = 25
80 - 99% = 17

Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 104, nodes: 112056
Average data length: 0.67, total dup: 100790, max dup: 25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 48
60 - 79% = 37
80 - 99% = 18

PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 26.87, total records: 13449
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 112, data page slots: 112, average fill: 65%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 111
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 10, nodes: 13449
Average data length: 0.01, total dup: 13322, max dup: 1021
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 5
60 - 79% = 3
80 - 99% = 2

PERF_ISQL_STAT (161)
Primary pointer page: 296, Index root page: 297
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PERF_ISQL_STAT_TRN (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PERF_LOG (162)
Primary pointer page: 299, Index root page: 300
Average record length: 142.15, total records: 921234
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 20783, data page slots: 20783, average fill: 86%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 20782

Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 1218, nodes: 921234
Average data length: 0.61, total dup: 476682, max dup: 28
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1077
60 - 79% = 104
80 - 99% = 37

Index PERF_LOG_GDSCODE (3)
Depth: 2, leaf buckets: 904, nodes: 921234
Average data length: 0.00, total dup: 921229, max dup: 904201
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 903
60 - 79% = 0
80 - 99% = 1

Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 1206, nodes: 921234
Average data length: 0.45, total dup: 856645, max dup: 5390
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1110
60 - 79% = 62
80 - 99% = 34

Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 1027, nodes: 921234
Average data length: 0.29, total dup: 896353, max dup: 106840
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 758
60 - 79% = 133
80 - 99% = 136

PHRASES (145)
Primary pointer page: 212, Index root page: 213
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_ID_DESC (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_NAME (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_PHRASES (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PSTORNED (151)
Primary pointer page: 248, Index root page: 249
Average record length: 52.40, total records: 79536
Average version length: 54.76, total versions: 3292, max versions: 1
Data pages: 926, data page slots: 926, average fill: 76%
Fill distribution:
0 - 19% = 1
20 - 39% = 3
40 - 59% = 2
60 - 79% = 892
80 - 99% = 28

Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 99, nodes: 79536
Average data length: 1.09, total dup: 66503, max dup: 144
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 91
60 - 79% = 0
80 - 99% = 5

Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 74, nodes: 79536
Average data length: 0.60, total dup: 72686, max dup: 92
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 37
60 - 79% = 32
80 - 99% = 5

RULES_FOR_PDISTR (152)
Primary pointer page: 250, Index root page: 251
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_PDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 7.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

RULES_FOR_QDISTR (139)
Primary pointer page: 190, Index root page: 191
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 1.57, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 6.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SEMAPHORES (156)
Primary pointer page: 263, Index root page: 264
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 573, max versions: 299
Data pages: 2, data page slots: 2, average fill: 92%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 2

Index PK_SEMAPHORES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 8.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index SEMAPHORES_TASK_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 18.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SETTINGS (137)
Primary pointer page: 183, Index root page: 184
Average record length: 98.32, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1

Index SETTINGS_MODE_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 114
Average data length: 23.07, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 180, Index root page: 181
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 178, Index root page: 179
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$DEP_DOCS (129)
Primary pointer page: 159, Index root page: 160
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_DEP_DOCS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$IDX_RECALC (132)
Primary pointer page: 169, Index root page: 170
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG (133)
Primary pointer page: 174, Index root page: 175
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 176, Index root page: 177
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_LOG (163)
Primary pointer page: 301, Index root page: 302
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_MON (131)
Primary pointer page: 167, Index root page: 168
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$RESULT_SET (130)
Primary pointer page: 162, Index root page: 163
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_DOC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_WARE_DOC (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$SHOPPING_CART (128)
Primary pointer page: 155, Index root page: 156
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_SHOPCART_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TRACE_STAT (276)
Primary pointer page: 513, Index root page: 95177
Average record length: 58.97, total records: 94
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 44%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0

WARES (144)
Primary pointer page: 210, Index root page: 211
Average record length: 78.00, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 6, data page slots: 6, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2

Index FK_WARES_WARE_GROUPS (3)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 0.14, total dup: 392, max dup: 62
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARES (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Depth: 2, leaf buckets: 2, nodes: 400
Average data length: 19.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 261, Index root page: 262
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARE_GROUPS (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 7.25, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index WARE_GROUPS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 15.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (258)
Primary pointer page: 645, Index root page: 646
Average record length: 0.28, total records: 172200
Average version length: 69.43, total versions: 171511, max versions: 1
Data pages: 2421, data page slots: 2423, average fill: 90%
Fill distribution:
0 - 19% = 59
20 - 39% = 55
40 - 59% = 16
60 - 79% = 17
80 - 99% = 2274

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 198, nodes: 172200
Average data length: 1.29, total dup: 150798, max dup: 29
Fill distribution:
0 - 19% = 4
20 - 39% = 2
40 - 59% = 83
60 - 79% = 64
80 - 99% = 45

XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 46.04, total records: 195195
Average version length: 69.17, total versions: 65739, max versions: 1
Data pages: 2853, data page slots: 2864, average fill: 78%
Fill distribution:
0 - 19% = 55
20 - 39% = 129
40 - 59% = 160
60 - 79% = 1307
80 - 99% = 1202

Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 188, nodes: 195195
Average data length: 0.15, total dup: 191021, max dup: 161
Fill distribution:
0 - 19% = 2
20 - 39% = 18
40 - 59% = 111
60 - 79% = 12
80 - 99% = 45

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 226, nodes: 195195
Average data length: 1.29, total dup: 170905, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 80
60 - 79% = 114
80 - 99% = 31

XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 0.06, total records: 201737
Average version length: 69.41, total versions: 201571, max versions: 1
Data pages: 2707, data page slots: 2707, average fill: 94%
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2
80 - 99% = 2703

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 208, nodes: 201737
Average data length: 0.97, total dup: 183268, max dup: 138
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 69
60 - 79% = 79
80 - 99% = 60

XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 15.85, total records: 898026
Average version length: 68.15, total versions: 692617, max versions: 1
Data pages: 12093, data page slots: 12093, average fill: 90%
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 0
60 - 79% = 2636
80 - 99% = 9455

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1163, nodes: 898026
Average data length: 1.16, total dup: 791653, max dup: 67
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 887
60 - 79% = 172
80 - 99% = 104

XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 8.23, total records: 205381
Average version length: 68.59, total versions: 180732, max versions: 1
Data pages: 3542, data page slots: 3582, average fill: 73%
Fill distribution:
0 - 19% = 184
20 - 39% = 534
40 - 59% = 212
60 - 79% = 253
80 - 99% = 2359

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 295, nodes: 205381
Average data length: 1.48, total dup: 174619, max dup: 71
Fill distribution:
0 - 19% = 0
20 - 39% = 33
40 - 59% = 167
60 - 79% = 90
80 - 99% = 5

XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 37.83, total records: 692264
Average version length: 68.24, total versions: 310813, max versions: 1
Data pages: 10034, data page slots: 10056, average fill: 79%
Fill distribution:
0 - 19% = 149
20 - 39% = 271
40 - 59% = 629
60 - 79% = 3877
80 - 99% = 5108

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 946, nodes: 692264
Average data length: 1.27, total dup: 603199, max dup: 41
Fill distribution:
0 - 19% = 0
20 - 39% = 38
40 - 59% = 667
60 - 79% = 151
80 - 99% = 90

XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 79.10, total records: 875654
Average version length: 80.29, total versions: 13657, max versions: 1
Data pages: 13053, data page slots: 13053, average fill: 80%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 6799
80 - 99% = 6253

Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 972, nodes: 875654
Average data length: 0.16, total dup: 855846, max dup: 129
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 725
60 - 79% = 194
80 - 99% = 47

Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 694, nodes: 875654
Average data length: 0.73, total dup: 769844, max dup: 49
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 107
60 - 79% = 23
80 - 99% = 561

Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 1110, nodes: 875654
Average data length: 0.76, total dup: 766692, max dup: 29
Fill distribution:
0 - 19% = 11
20 - 39% = 1
40 - 59% = 819
60 - 79% = 228
80 - 99% = 51

XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 70.31, total records: 596489
Average version length: 80.13, total versions: 73298, max versions: 1
Data pages: 9021, data page slots: 9029, average fill: 80%
Fill distribution:
0 - 19% = 41
20 - 39% = 46
40 - 59% = 71
60 - 79% = 5219
80 - 99% = 3644

Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 610, nodes: 596489
Average data length: 0.15, total dup: 583924, max dup: 217
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 340
60 - 79% = 222
80 - 99% = 46

Index XQS_1000_3300_RCV_ID (2)
Depth: 2, leaf buckets: 479, nodes: 596489
Average data length: 0.81, total dup: 519751, max dup: 14
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 79
60 - 79% = 1
80 - 99% = 395

Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 730, nodes: 596489
Average data length: 0.71, total dup: 527900, max dup: 38
Fill distribution:
0 - 19% = 29
20 - 39% = 1
40 - 59% = 429
60 - 79% = 239
80 - 99% = 32

XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 78.14, total records: 897907
Average version length: 80.86, total versions: 24903, max versions: 1
Data pages: 13385, data page slots: 13385, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 7275
80 - 99% = 6110

Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 940, nodes: 897907
Average data length: 0.05, total dup: 892425, max dup: 916
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 649
60 - 79% = 215
80 - 99% = 75

Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 666, nodes: 897907
Average data length: 0.71, total dup: 791508, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 40
60 - 79% = 2
80 - 99% = 623

Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 1078, nodes: 897907
Average data length: 0.72, total dup: 792115, max dup: 138
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 712
60 - 79% = 264
80 - 99% = 95

XQS_2000_3300 (267)
Primary pointer page: 683, Index root page: 684
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_DOC_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_RCV_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_SND_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQS_2100_3300 (268)
Primary pointer page: 691, Index root page: 692
Average record length: 72.66, total records: 710823
Average version length: 80.16, total versions: 67877, max versions: 1
Data pages: 11247, data page slots: 11268, average fill: 77%
Fill distribution:
0 - 19% = 155
20 - 39% = 251
40 - 59% = 560
60 - 79% = 6296
80 - 99% = 3985

Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 659, nodes: 710823
Average data length: 0.05, total dup: 706617, max dup: 935
Fill distribution:
0 - 19% = 2
20 - 39% = 7
40 - 59% = 254
60 - 79% = 265
80 - 99% = 131

Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 653, nodes: 710823
Average data length: 0.82, total dup: 618765, max dup: 14
Fill distribution:
0 - 19% = 6
20 - 39% = 34
40 - 59% = 186
60 - 79% = 20
80 - 99% = 407

Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 759, nodes: 710823
Average data length: 0.71, total dup: 628249, max dup: 71
Fill distribution:
0 - 19% = 2
20 - 39% = 7
40 - 59% = 256
60 - 79% = 355
80 - 99% = 139

XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 59.77, total records: 298697
Average version length: 68.27, total versions: 37202, max versions: 1
Data pages: 4019, data page slots: 4019, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 3112
80 - 99% = 906

Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 265, nodes: 298697
Average data length: 0.22, total dup: 289432, max dup: 185
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 84
60 - 79% = 111
80 - 99% = 70

Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 310, nodes: 298697
Average data length: 0.82, total dup: 259957, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 113
60 - 79% = 135
80 - 99% = 62

ZDOC_DATA (228)
Primary pointer page: 564, Index root page: 565
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZDOC_LIST (227)
Primary pointer page: 560, Index root page: 561
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZINVNT_TURNOVER_LOG (229)
Primary pointer page: 567, Index root page: 568
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPDISTR (232)
Primary pointer page: 573, Index root page: 574
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPSTORNED (233)
Primary pointer page: 575, Index root page: 576
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQDISTR (230)
Primary pointer page: 569, Index root page: 570
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQSTORNED (231)
Primary pointer page: 571, Index root page: 572
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_DOC_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_RCV_ID (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_SND_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_DEP_DOCS (226)
Primary pointer page: 558, Index root page: 559
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_SHOPPING_CART (225)
Primary pointer page: 556, Index root page: 557
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Z_USED_VIEWS (146)
Primary pointer page: 214, Index root page: 215
Average record length: 29.19, total records: 32
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index Z_USED_VIEWS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 32
Average data length: 10.78, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Done for 17800 ms, from 2:38:40.18 to 2:38:57.98.

Analyzing DB stat log: obtaining values of total records and versions

TABLE_NAME TOTAL_RECS TOTAL_VERS VERS_PERCENT
AGENTS 50 0 0.0000
BUSINESS_OPS 19 0 0.0000
DOC_DATA 413354 11413 2.7610
DOC_LIST 63590 4275 6.7227
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 50799 12699.7500
INVNT_TURNOVER_LOG 107525 107091 99.5963
MONEY_SALDO 49 2691 5491.8367
MONEY_TURNOVER_LOG 5061 5042 99.6245
OPTYPES 9 0 0.0000
PDISTR 112056 70755 63.1425
PERF_ESTIMATED 13449 2 0.0148
PERF_LOG 921234 1 0.0001
PSTORNED 79536 3292 4.1390
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 573 14325.0000
SETTINGS 114 0 0.0000
TRACE_STAT 94 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 172200 171511 99.5998
XQD_1000_3300 195195 65739 33.6786
XQD_1200_2000 201737 201571 99.9177
XQD_2000_3300 898026 692617 77.1266
XQD_2100_3300 205381 180732 87.9984
XQD_3300_3400 692264 310813 44.8980
XQS_1000_1200 875654 13657 1.5596
XQS_1000_3300 596489 73298 12.2882
XQS_1200_2000 897907 24903 2.7734
XQS_2100_3300 710823 67877 9.5490
XQS_3300_3400 298697 37202 12.4547
Z_USED_VIEWS 32 0 0.0000
Done for 3960 ms, from 2:39:09.75 to 2:39:13.71.

Database validation

02:39:14.05 Validation started

02:39:14.05 Relation 140 (DOC_LIST)
02:39:14.05 process pointer page 0 of 1
02:39:14.11 Index 1 (PK_DOC_LIST)
02:39:14.13 Index 2 (DOC_LIST_ID_DESC)
02:39:14.15 Index 3 (FK_DOC_LIST_AGENTS)
02:39:14.16 Relation 140 (DOC_LIST) is ok

02:39:14.16 Relation 141 (DOC_DATA)
02:39:14.16 process pointer page 0 of 3
02:39:14.27 process pointer page 1 of 3
02:39:14.30 process pointer page 2 of 3
02:39:14.32 Index 2 (DOC_DATA_DOC_WARE_UNQ)
02:39:14.40 Index 3 (DOC_DATA_ID_DESC)
02:39:14.44 Index 4 (FK_DOC_DATA_DOC_LIST)
02:39:14.47 Relation 141 (DOC_DATA) is ok

02:39:14.47 Relation 147 (INVNT_SALDO)
02:39:14.47 process pointer page 0 of 1
02:39:14.50 Index 1 (PK_INVNT_SALDO)
02:39:14.50 Relation 147 (INVNT_SALDO) is ok

02:39:14.50 Relation 150 (PDISTR)
02:39:14.50 process pointer page 0 of 1
02:39:14.55 Index 2 (PDISTR_SND_ID)
02:39:14.55 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
02:39:14.57 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
02:39:14.57 Index 5 (PDISTR_AGENT_ID)
02:39:14.58 Relation 150 (PDISTR) is ok

02:39:14.58 Relation 151 (PSTORNED)
02:39:14.58 process pointer page 0 of 1
02:39:14.60 Index 2 (PSTORNED_SND_ID)
02:39:14.60 Index 3 (PSTORNED_RCV_ID)
02:39:14.60 Relation 151 (PSTORNED) is ok

02:39:14.60 Relation 156 (SEMAPHORES)
02:39:14.60 process pointer page 0 of 1
02:39:14.61 Index 1 (PK_SEMAPHORES)
02:39:14.61 Index 2 (SEMAPHORES_TASK_UNQ)
02:39:14.61 Relation 156 (SEMAPHORES) is ok

02:39:14.61 Relation 157 (INVNT_TURNOVER_LOG)
02:39:14.61 process pointer page 0 of 1
02:39:14.64 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
02:39:14.66 Relation 157 (INVNT_TURNOVER_LOG) is ok

02:39:14.66 Relation 160 (PERF_ESTIMATED)
02:39:14.66 process pointer page 0 of 1
02:39:14.66 Index 1 (PERF_EST_MINUTE_SINCE_START)
02:39:14.66 Relation 160 (PERF_ESTIMATED) is ok

02:39:14.66 Relation 161 (PERF_ISQL_STAT)
02:39:14.66 process pointer page 0 of 1
02:39:14.66 Index 1 (PERF_ISQL_STAT_TRN)
02:39:14.66 Relation 161 (PERF_ISQL_STAT) is ok

02:39:14.66 Relation 162 (PERF_LOG)
02:39:14.66 process pointer page 0 of 11
02:39:14.68 process pointer page 1 of 11
02:39:14.71 process pointer page 2 of 11
02:39:14.72 process pointer page 3 of 11
02:39:14.74 process pointer page 4 of 11
02:39:14.77 process pointer page 5 of 11
02:39:14.79 process pointer page 6 of 11
02:39:14.82 process pointer page 7 of 11
02:39:14.85 process pointer page 8 of 11
02:39:14.88 process pointer page 9 of 11
02:39:14.89 process pointer page 10 of 11
02:39:14.91 Index 1 (PERF_LOG_DTS_BEG_DESC)
02:39:14.99 Index 2 (PERF_LOG_UNIT)
02:39:15.10 Index 3 (PERF_LOG_TRN_DESC)
02:39:15.22 Index 4 (PERF_LOG_GDSCODE)
02:39:15.35 Relation 162 (PERF_LOG) is ok

02:39:15.35 Relation 166 (V_STOPTEST)
02:39:15.35 Relation 166 (V_STOPTEST) is ok

02:39:15.35 Relation 183 (V_QDISTR_SOURCE)
02:39:15.35 Relation 183 (V_QDISTR_SOURCE) is ok

02:39:15.35 Relation 184 (V_QSTORNED_SOURCE)
02:39:15.35 Relation 184 (V_QSTORNED_SOURCE) is ok

02:39:15.35 Relation 258 (XQD_1000_1200)
02:39:15.35 process pointer page 0 of 2
02:39:15.44 process pointer page 1 of 2
02:39:15.47 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
02:39:15.50 Relation 258 (XQD_1000_1200) is ok

02:39:15.50 Relation 259 (XQD_1200_2000)
02:39:15.50 process pointer page 0 of 2
02:39:15.66 process pointer page 1 of 2
02:39:15.69 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
02:39:15.71 Relation 259 (XQD_1200_2000) is ok

02:39:15.71 Relation 260 (XQD_1000_3300)
02:39:15.71 process pointer page 0 of 2
02:39:15.77 process pointer page 1 of 2
02:39:15.78 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
02:39:15.80 Index 2 (XQD_1000_3300_DOC)
02:39:15.81 Relation 260 (XQD_1000_3300) is ok

02:39:15.81 Relation 261 (XQD_2000_3300)
02:39:15.81 process pointer page 0 of 7
02:39:15.88 process pointer page 1 of 7
02:39:15.94 process pointer page 2 of 7
02:39:16.00 process pointer page 3 of 7
02:39:16.05 process pointer page 4 of 7
02:39:16.08 process pointer page 5 of 7
02:39:16.11 process pointer page 6 of 7
02:39:16.13 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
02:39:16.19 Relation 261 (XQD_2000_3300) is ok

02:39:16.19 Relation 262 (XQD_2100_3300)
02:39:16.19 process pointer page 0 of 2
02:39:16.24 process pointer page 1 of 2
02:39:16.27 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
02:39:16.30 Relation 262 (XQD_2100_3300) is ok

02:39:16.30 Relation 263 (XQD_3300_3400)
02:39:16.30 process pointer page 0 of 6
02:39:16.42 process pointer page 1 of 6
02:39:16.58 process pointer page 2 of 6
02:39:16.70 process pointer page 3 of 6
02:39:16.78 process pointer page 4 of 6
02:39:16.83 process pointer page 5 of 6
02:39:16.83 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
02:39:16.92 Relation 263 (XQD_3300_3400) is ok

02:39:16.92 Relation 264 (XQS_1000_1200)
02:39:16.92 process pointer page 0 of 7
02:39:16.95 process pointer page 1 of 7
02:39:17.03 process pointer page 2 of 7
02:39:17.09 process pointer page 3 of 7
02:39:17.14 process pointer page 4 of 7
02:39:17.22 process pointer page 5 of 7
02:39:17.27 process pointer page 6 of 7
02:39:17.28 Index 1 (XQS_1000_1200_DOC_ID)
02:39:17.41 Index 2 (XQS_1000_1200_SND_ID)
02:39:17.58 Index 3 (XQS_1000_1200_RCV_ID)
02:39:17.66 Relation 264 (XQS_1000_1200) is ok

02:39:17.66 Relation 265 (XQS_1200_2000)
02:39:17.66 process pointer page 0 of 7
02:39:17.69 process pointer page 1 of 7
02:39:17.72 process pointer page 2 of 7
02:39:17.75 process pointer page 3 of 7
02:39:17.78 process pointer page 4 of 7
02:39:17.81 process pointer page 5 of 7
02:39:17.84 process pointer page 6 of 7
02:39:17.86 Index 1 (XQS_1200_2000_DOC_ID)
02:39:17.92 Index 2 (XQS_1200_2000_SND_ID)
02:39:18.00 Index 3 (XQS_1200_2000_RCV_ID)
02:39:18.05 Relation 265 (XQS_1200_2000) is ok

02:39:18.05 Relation 266 (XQS_1000_3300)
02:39:18.05 process pointer page 0 of 5
02:39:18.08 process pointer page 1 of 5
02:39:18.09 process pointer page 2 of 5
02:39:18.12 process pointer page 3 of 5
02:39:18.15 process pointer page 4 of 5
02:39:18.17 Index 1 (XQS_1000_3300_DOC_ID)
02:39:18.22 Index 2 (XQS_1000_3300_SND_ID)
02:39:18.25 Index 3 (XQS_1000_3300_RCV_ID)
02:39:18.30 Relation 266 (XQS_1000_3300) is ok

02:39:18.30 Relation 267 (XQS_2000_3300)
02:39:18.30 process pointer page 0 of 1
02:39:18.30 Index 1 (XQS_2000_3300_DOC_ID)
02:39:18.30 Index 2 (XQS_2000_3300_SND_ID)
02:39:18.30 Index 3 (XQS_2000_3300_RCV_ID)
02:39:18.30 Relation 267 (XQS_2000_3300) is ok

02:39:18.30 Relation 268 (XQS_2100_3300)
02:39:18.30 process pointer page 0 of 6
02:39:18.31 process pointer page 1 of 6
02:39:18.34 process pointer page 2 of 6
02:39:18.37 process pointer page 3 of 6
02:39:18.40 process pointer page 4 of 6
02:39:18.42 process pointer page 5 of 6
02:39:18.44 Index 1 (XQS_2100_3300_DOC_ID)
02:39:18.51 Index 2 (XQS_2100_3300_SND_ID)
02:39:18.59 Index 3 (XQS_2100_3300_RCV_ID)
02:39:18.70 Relation 268 (XQS_2100_3300) is ok

02:39:18.70 Relation 269 (XQS_3300_3400)
02:39:18.70 process pointer page 0 of 3
02:39:18.76 process pointer page 1 of 3
02:39:18.83 process pointer page 2 of 3
02:39:18.83 Index 1 (XQS_3300_3400_DOC_ID)
02:39:18.86 Index 2 (XQS_3300_3400_SND_ID)
02:39:18.92 Relation 269 (XQS_3300_3400) is ok

02:39:18.92 Relation 276 (TRACE_STAT)
02:39:18.92 process pointer page 0 of 1
02:39:18.92 Relation 276 (TRACE_STAT) is ok

02:39:18.92 Validation finished
Done for 5180 ms, from 2:39:13.79 to 2:39:18.97.

Differences between old and current firebird.log

2:39:19.84. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 5 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-09-01 02:39 309 oltp25_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

Comparison of old and new firebird.log (get messages that appeared during test):

+++ Start of comparison +++
result: files match. No new messages appeared in firebird.log during test ran.
+++ End of comparison +++

Final processing ISQL logs in e:\temp\logs.oltp25


Remove 401 logs of every ISQL session if there were no serious errors.

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp25\oltp25_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2016-09-01 2:39:22.29 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html