Virt-H Executive Summary Report Date: June 9, 2015 Database Scale Factor: 1000 Total Data Storage/Database Size: 0M Start of Database Load: 06/09/15 15:41:35 End of Database Load: 06/09/15 16:14:22 Database Load Time: 0:32:47 Query Streams for Throughput Test: 7 Virt-H Power: 926181.8 Virt-H Throughput: 839162.6 Virt-H Composite Query-per-Hour Metric (Qph@1000GB): 881599.2 Total System Price Over 3 Years: Base ? Virt-H Price Performance Metric ($/Qph@1000GB): Base ? Measurement Interval: Measurement Interval in Throughput Test (Ts) = 660.759000 seconds Duration of stream execution: Start Date/Time End Date/Time Duration Stream 0 06/09/2015 16:33:40 06/09/2015 16:35:57 0:02:17 Stream 1 06/09/2015 16:36:00 06/09/2015 16:45:41 0:09:41 Stream 2 06/09/2015 16:36:00 06/09/2015 16:45:51 0:09:51 Stream 3 06/09/2015 16:36:00 06/09/2015 16:45:29 0:09:29 Stream 4 06/09/2015 16:36:00 06/09/2015 16:45:42 0:09:42 Stream 5 06/09/2015 16:36:00 06/09/2015 16:45:44 0:09:44 Stream 6 06/09/2015 16:36:00 06/09/2015 16:45:50 0:09:50 Stream 7 06/09/2015 16:36:00 06/09/2015 16:45:51 0:09:51 Refresh 0 06/09/2015 16:33:40 06/09/2015 16:33:59 0:00:19 06/09/2015 16:35:56 06/09/2015 16:35:59 0:00:03 Refresh 1 06/09/2015 16:46:39 06/09/2015 16:47:00 0:00:21 Refresh 2 06/09/2015 16:36:00 06/09/2015 16:38:27 0:02:27 Refresh 3 06/09/2015 16:38:27 06/09/2015 16:40:57 0:02:30 Refresh 4 06/09/2015 16:40:57 06/09/2015 16:44:09 0:03:12 Refresh 5 06/09/2015 16:44:09 06/09/2015 16:45:56 0:01:47 Refresh 6 06/09/2015 16:45:55 06/09/2015 16:46:18 0:00:23 Refresh 7 06/09/2015 16:46:18 06/09/2015 16:46:39 0:00:21 Numerical Quantities Summary Timing Intervals in Seconds: Query Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Stream 0 5.479395 0.630042 4.170425 0.769800 10.975571 11.149759 3.599319 5.242749 Stream 1 14.923393 12.440212 21.599117 1.929207 37.509717 31.233371 24.420358 31.944497 Stream 2 13.969045 1.831614 22.356862 6.908387 55.082956 44.333671 21.069933 54.615483 Stream 3 16.272047 3.695984 20.015891 3.146094 41.301298 36.389032 25.046903 34.335514 Stream 4 17.680026 6.348517 26.329344 2.568638 46.274138 44.530604 28.174624 45.726792 Stream 5 12.919055 4.249653 28.734543 2.492635 43.375903 44.122795 17.120901 62.724989 Stream 6 26.449658 5.745455 23.286786 16.200083 66.275224 47.014980 45.590417 19.113806 Stream 7 20.424288 5.621585 16.604985 4.445895 48.350149 38.252307 23.907803 27.591035 Min Qi 12.919055 1.831614 16.604985 1.929207 37.509717 31.233371 17.120901 19.113806 Max Qi 26.449658 12.440212 28.734543 16.200083 66.275224 47.014980 45.590417 62.724989 Avg Qi 17.519645 5.704717 22.703933 5.384420 48.309912 40.839537 26.475848 39.436017 Query Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Stream 0 13.714954 5.019368 10.884449 1.487462 16.231959 1.511541 3.494820 2.855718 Stream 1 45.964060 21.286496 29.928543 7.545850 83.096048 10.461210 14.770626 17.309562 Stream 2 58.193000 14.733047 39.950613 4.531075 94.304999 5.683222 12.610061 9.882627 Stream 3 64.354500 34.868689 32.455954 9.139478 51.717901 6.823625 20.974001 16.203570 Stream 4 44.877564 67.531831 25.196062 9.024894 55.029758 4.075100 25.120823 19.872642 Stream 5 52.419025 18.388613 34.979090 8.641101 69.263839 8.248048 23.224911 9.969377 Stream 6 38.815437 17.329812 35.151037 25.364998 43.267176 18.405776 30.139764 19.877411 Stream 7 95.549177 26.950397 35.710773 4.037201 87.262216 8.620524 14.796153 7.791257 Min Qi 38.815437 14.733047 25.196062 4.037201 43.267176 4.075100 12.610061 7.791257 Max Qi 95.549177 67.531831 39.950613 25.364998 94.304999 18.405776 30.139764 19.877411 Avg Qi 57.167538 28.726984 33.338867 9.754942 69.134562 8.902501 20.233763 14.415207 Query Q17 Q18 Q19 Q20 Q21 Q22 RF1 RF2 Stream 0 3.793893 5.405475 1.802979 5.198560 4.094445 0.818421 18.979743 2.682319 Stream 1 34.448063 20.642194 18.735921 69.298189 24.860768 5.626639 18.866652 2.745627 Stream 2 25.990583 22.460160 19.258257 42.636743 10.074291 8.289354 118.367898 28.060541 Stream 3 15.646905 13.300684 21.579305 70.990027 25.734354 4.195101 111.050275 39.522911 Stream 4 17.623825 19.736052 10.527663 35.713020 24.383778 3.199915 156.707961 35.255697 Stream 5 29.623954 14.810271 10.651884 51.932118 22.480619 12.042893 103.658458 2.668301 Stream 6 23.907778 17.930582 7.948122 37.538625 9.894431 2.647795 18.882665 3.355773 Stream 7 22.759909 13.275718 9.023556 38.394565 30.458740 3.591619 18.927793 2.383141 Min Qi 15.646905 13.275718 7.948122 35.713020 9.894431 2.647795 18.866652 2.383141 Max Qi 34.448063 22.460160 21.579305 70.990027 30.458740 12.042893 156.707961 39.522911 Avg Qi 24.285860 17.450809 13.960673 49.500470 21.126712 5.656188 78.065957 16.284570