MS SQLIO Tests of ION SR-71mach4 | |||||||||||||
Server is ION SR-71mach4 with (3) 4TB RAID 5 volumes or (3) 2.2TB RAID 10 volumes | |||||||||||||
The SR-71mach4 system under test included (2) Intel Xeon E5-2690V2 processors, 10-cores at 3.0GHz. | |||||||||||||
The SR-71mach4 system under test had Hyper-Threading Technology and Intel SpeedStep DISABLED. | |||||||||||||
The SR-71mach4 system under test included 32GB 1600MHz ECC DDR3 RAM. | |||||||||||||
1min rest between each set of (5) 30 minute tests. | |||||||||||||
Detailed output from tests on RAID 5 and RAID 10 follow.. | |||||||||||||
SQLIO: 8kB Random Write for 5x30 minutes | |||||||||||||
mach4 RAID 5 | mach4 RAID 10 | ||||||||||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | |||||||||
1 | 91,771 | 3 | 205,710 | 1 | |||||||||
2 | 91,724 | 3 | 199,119 | 1 | |||||||||
3 | 91,693 | 3 | 198,998 | 1 | |||||||||
4 | 91,699 | 3 | 199,342 | 1 | |||||||||
5 | 91,703 | 3 | 198,587 | 1 | |||||||||
Trimmed Mean | 91,718 | 3 | 200,351 | 1 | |||||||||
717 | Mbps | 1565 | Mbps | ||||||||||
SQLIO: 8kB Random Read for 5x30 minutes | |||||||||||||
mach4 RAID 5 | mach4 RAID 10 | ||||||||||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | |||||||||
1 | 808,360 | 0 | 507,655 | 0 | |||||||||
2 | 815,031 | 0 | 507,598 | 0 | |||||||||
3 | 805,969 | 0 | 504,363 | 0 | |||||||||
4 | 808,026 | 0 | 507,078 | 0 | |||||||||
5 | 816,738 | 0 | 507,357 | 0 | |||||||||
Trimmed Mean | 810,825 | 0 | 506,810 | 0 | |||||||||
6335 | Mbps | 3959 | Mbps | ||||||||||
SQLIO: 8kB Sequential Write for 5x30 minutes | |||||||||||||
mach4 RAID 5 | mach4 RAID 10 | ||||||||||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | |||||||||
1 | 30,011 | 12 | 205,613 | 1 | |||||||||
2 | 30,054 | 12 | 274,188 | 1 | |||||||||
3 | 30,322 | 12 | 295,717 | 0 | |||||||||
4 | 30,360 | 12 | 295,373 | 0 | |||||||||
5 | 31,000 | 11 | 300,390 | 0 | |||||||||
Trimmed Mean | 30,350 | 12 | 274,256 | 0 | |||||||||
237 | Mbps | 2143 | Mbps | ||||||||||
SQLIO: 8kB Sequential Read for 5x30 minutes | |||||||||||||
mach4 RAID 5 | mach4 RAID 10 | ||||||||||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | |||||||||
1 | 803,547 | 0 | 560,008 | 0 | |||||||||
2 | 807,637 | 0 | 559,760 | 0 | |||||||||
3 | 799,133 | 0 | 559,070 | 0 | |||||||||
4 | 810,910 | 0 | 558,966 | 0 | |||||||||
5 | 804,087 | 0 | 558,770 | 0 | |||||||||
Trimmed Mean | 805,063 | 0 | 559,315 | 0 | |||||||||
6290 | Mbps | 4370 | Mbps | ||||||||||
SQLIO: 64kB Random Write for 5x30 minutes | |||||||||||||
mach4 RAID 5 | mach4 RAID 10 | ||||||||||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | |||||||||
1 | 19,202 | 19 | 30,027 | 12 | |||||||||
2 | 18,581 | 20 | 25,162 | 14 | |||||||||
3 | 20,246 | 18 | 26,114 | 14 | |||||||||
4 | 20,018 | 18 | 26,211 | 14 | |||||||||
5 | 19,564 | 19 | 26,380 | 14 | |||||||||
Trimmed Mean | 19,522 | 19 | 26,779 | 14 | |||||||||
1220 | Mbps | 1674 | Mbps | ||||||||||
SQLIO: 64kB Random Read for 5x30 minutes | |||||||||||||
mach4 RAID 5 | mach4 RAID 10 | ||||||||||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | |||||||||
1 | 98,767 | 3 | 133,460 | 2 | |||||||||
2 | 129,592 | 2 | 133,309 | 2 | |||||||||
3 | 97,377 | 3 | 133,332 | 2 | |||||||||
4 | 129,479 | 2 | 133,275 | 2 | |||||||||
5 | 129,496 | 2 | 133,287 | 2 | |||||||||
Trimmed Mean | 116,942 | 2 | 133,333 | 2 | |||||||||
7309 | Mbps | 8333 | Mbps | ||||||||||
SQLIO: 64kB Sequential Write for 5x30 minutes | |||||||||||||
mach4 RAID 5 | mach4 RAID 10 | ||||||||||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | |||||||||
1 | 28,625 | 12 | 27,502 | 13 | |||||||||
2 | 35,291 | 10 | 48,730 | 7 | |||||||||
3 | 37,511 | 9 | 63,625 | 5 | |||||||||
4 | 36,556 | 10 | 70,841 | 4 | |||||||||
5 | 40,536 | 8 | 71,297 | 4 | |||||||||
Trimmed Mean | 35,704 | 10 | 56,399 | 7 | |||||||||
2231 | Mbps | 3525 | Mbps | ||||||||||
SQLIO: 64kB Sequential Read for 5x30 minutes | |||||||||||||
mach4 RAID 5 | mach4 RAID 10 | ||||||||||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | |||||||||
1 | 130,531 | 2 | 132,709 | 2 | |||||||||
2 | 102,714 | 3 | 132,174 | 2 | |||||||||
3 | 130,077 | 2 | 132,006 | 2 | |||||||||
4 | 101,447 | 3 | 132,016 | 2 | |||||||||
5 | 130,040 | 2 | 131,953 | 2 | |||||||||
Trimmed Mean | 118,962 | 2 | 132,171 | 2 | |||||||||
7435 | Mbps | 8261 | Mbps |
mach4 RAID 5 | |
SQLIO: 8kB Random Write for 5x30 minutes | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 91771.23 | |
MBs/sec: 716.96 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 75 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 3 46 35 11 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 91723.82 | |
MBs/sec: 716.59 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 75 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 4 47 30 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 91693.31 | |
MBs/sec: 716.35 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 77 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 4 47 30 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 91699.14 | |
MBs/sec: 716.39 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 76 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 4 47 30 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 91703.17 | |
MBs/sec: 716.43 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 82 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 4 47 30 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 8kB Random Read for 5x30 minutes | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 808360.02 | |
MBs/sec: 6315.31 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 34 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 96 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 815031.07 | |
MBs/sec: 6367.43 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 25 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 96 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 805968.93 | |
MBs/sec: 6296.63 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 25 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 95 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 808026.14 | |
MBs/sec: 6312.70 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 23 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 96 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 816738.04 | |
MBs/sec: 6380.76 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 21 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 96 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 8kB Sequential Write for 5x30 minutes | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30011.28 | |
MBs/sec: 234.46 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 222 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 3 5 4 4 5 4 4 4 4 4 4 4 3 3 3 3 3 3 3 2 2 2 2 13 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30054.49 | |
MBs/sec: 234.80 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 213 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 3 5 4 4 5 4 4 4 4 4 4 4 3 3 3 3 3 3 3 2 2 2 2 13 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30322.23 | |
MBs/sec: 236.89 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 229 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 3 5 4 4 5 4 4 4 4 4 4 4 3 3 3 3 3 3 2 2 2 2 2 13 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30360.15 | |
MBs/sec: 237.18 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 208 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 3 5 4 4 5 4 4 4 4 4 4 4 3 3 3 3 3 3 2 2 2 2 2 13 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 31000.23 | |
MBs/sec: 242.18 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 11 | |
Max_Latency(ms): 208 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 11 3 5 4 5 5 4 4 4 4 4 4 4 3 3 3 3 3 3 2 2 2 2 2 12 | |
SQLIO: 8kB Sequential Read for 5x30 minutes | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 803547.40 | |
MBs/sec: 6277.71 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 26 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 95 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 807636.93 | |
MBs/sec: 6309.66 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 25 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 95 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 799132.84 | |
MBs/sec: 6243.22 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 23 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 95 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 810910.02 | |
MBs/sec: 6335.23 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 21 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 96 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 804087.04 | |
MBs/sec: 6281.93 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 24 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 95 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 64kB Random Write for 5x30 minutes | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 19201.83 | |
MBs/sec: 1200.11 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 19 | |
Max_Latency(ms): 191 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 2 3 4 5 5 4 4 4 4 4 3 3 3 3 3 2 2 2 2 2 2 2 30 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 18581.11 | |
MBs/sec: 1161.31 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 20 | |
Max_Latency(ms): 223 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 2 4 5 5 5 5 4 4 4 4 3 3 3 3 2 2 2 2 2 2 2 2 30 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 20246.19 | |
MBs/sec: 1265.38 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 18 | |
Max_Latency(ms): 208 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 3 5 6 6 6 5 5 4 4 3 3 3 2 2 2 2 2 2 1 1 1 1 28 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 20018.30 | |
MBs/sec: 1251.14 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 18 | |
Max_Latency(ms): 182 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 3 5 6 6 6 5 5 4 4 3 3 3 2 2 2 2 2 2 1 1 1 1 28 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 19564.26 | |
MBs/sec: 1222.76 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 19 | |
Max_Latency(ms): 188 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 2 4 6 6 6 6 5 5 4 4 3 3 3 2 2 2 2 2 1 1 1 1 1 28 | |
SQLIO: 64kB Random Read for 5x30 minutes | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 98767.12 | |
MBs/sec: 6172.94 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 95 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 4 17 26 23 13 6 3 2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 129591.63 | |
MBs/sec: 8099.47 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 74 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 4 19 31 26 13 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 97377.27 | |
MBs/sec: 6086.07 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 95 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 4 17 26 23 13 6 3 2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 129479.18 | |
MBs/sec: 8092.44 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 74 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 4 19 31 26 13 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 129495.78 | |
MBs/sec: 8093.48 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 76 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 4 19 31 26 13 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 64kB Sequential Write for 5x30 minutes | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 28625.14 | |
MBs/sec: 1789.07 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 214 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 6 10 10 8 5 4 3 2 2 2 2 2 2 2 3 3 2 2 2 2 2 2 17 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 35290.77 | |
MBs/sec: 2205.67 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 10 | |
Max_Latency(ms): 193 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 1 9 10 9 7 6 4 4 3 3 3 3 3 3 3 3 3 2 2 2 2 2 2 1 10 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37511.10 | |
MBs/sec: 2344.44 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 9 | |
Max_Latency(ms): 241 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 1 13 11 8 6 5 4 4 3 3 3 3 3 3 3 3 3 2 2 2 2 2 1 1 8 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 36556.24 | |
MBs/sec: 2284.76 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 10 | |
Max_Latency(ms): 248 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 1 11 11 9 7 5 4 4 3 3 3 3 3 3 3 3 3 2 2 2 2 2 2 1 9 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 40535.67 | |
MBs/sec: 2533.47 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 8 | |
Max_Latency(ms): 238 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 1 16 11 7 5 4 4 4 3 3 3 3 3 3 3 3 3 2 2 2 2 2 1 1 6 | |
SQLIO: 64kB Sequential Read for 5x30 minutes | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 130530.50 | |
MBs/sec: 8158.15 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 62 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 3 55 38 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 102714.10 | |
MBs/sec: 6419.63 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 75 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 3 47 35 6 2 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 130076.65 | |
MBs/sec: 8129.79 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 60 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 3 53 40 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 101446.81 | |
MBs/sec: 6340.42 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 78 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 3 46 36 6 2 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922644 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: D:\iobw.tst | |
using specified size: 4194304 MB for file: E:\iobw.tst | |
using specified size: 4194304 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 130040.09 | |
MBs/sec: 8127.50 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 156 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 3 54 39 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
mach4 RAID 10 | |
SQLIO: 8kB Random Write for 5x30 minutes | |
2013-11-18 10:50:48 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 205709.64 | |
MBs/sec: 1607.10 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 1 | |
Max_Latency(ms): 41 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 44 23 12 9 6 3 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 199118.79 | |
MBs/sec: 1555.61 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 1 | |
Max_Latency(ms): 149 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 47 18 12 9 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 198997.57 | |
MBs/sec: 1554.66 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 1 | |
Max_Latency(ms): 39 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 46 18 12 9 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 199341.62 | |
MBs/sec: 1557.35 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 1 | |
Max_Latency(ms): 42 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 46 18 13 9 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 198587.06 | |
MBs/sec: 1551.46 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 1 | |
Max_Latency(ms): 36 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 46 18 12 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 8kB Random Read for 5x30 minutes | |
2013-11-18 13:21:48 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 507654.99 | |
MBs/sec: 3966.05 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 23 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 77 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 507598.30 | |
MBs/sec: 3965.61 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 10 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 77 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 504362.68 | |
MBs/sec: 3940.33 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 29 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 76 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 507078.38 | |
MBs/sec: 3961.54 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 17 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 77 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 507357.32 | |
MBs/sec: 3963.72 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 21 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 77 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 8kB Sequential Write for 5x30 minutes | |
2013-11-18 15:52:48 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 205613.09 | |
MBs/sec: 1606.35 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 1 | |
Max_Latency(ms): 164 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 49 17 11 9 6 3 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 274187.87 | |
MBs/sec: 2142.09 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 1 | |
Max_Latency(ms): 136 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 19 72 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 295716.82 | |
MBs/sec: 2310.28 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 137 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 14 82 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 295372.59 | |
MBs/sec: 2307.59 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 134 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 14 81 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 300390.37 | |
MBs/sec: 2346.79 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 38 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 7 90 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 8kB Sequential Read for 5x30 minutes | |
2013-11-18 18:23:48 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 560007.62 | |
MBs/sec: 4375.05 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 139 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 90 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 559759.68 | |
MBs/sec: 4373.12 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 156 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 91 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 559069.71 | |
MBs/sec: 4367.73 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 20 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 90 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 558965.76 | |
MBs/sec: 4366.92 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 14 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 91 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 558770.38 | |
MBs/sec: 4365.39 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 22 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 90 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 64kB Random Write for 5x30 minutes | |
2013-11-18 20:54:48 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30027.44 | |
MBs/sec: 1876.71 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 161 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 16 9 5 4 3 3 3 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 19 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 25162.26 | |
MBs/sec: 1572.64 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 14 | |
Max_Latency(ms): 86 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 11 7 6 5 4 3 3 2 2 2 1 1 1 1 1 2 2 2 2 2 3 3 3 3 29 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 26114.39 | |
MBs/sec: 1632.14 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 14 | |
Max_Latency(ms): 88 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 12 8 6 5 4 3 2 2 2 1 1 1 1 1 1 2 2 2 2 2 3 3 3 3 28 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 26211.06 | |
MBs/sec: 1638.19 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 14 | |
Max_Latency(ms): 94 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 11 8 6 5 4 3 2 2 2 2 1 1 1 1 1 2 2 2 2 2 3 3 3 3 28 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 26380.34 | |
MBs/sec: 1648.77 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 14 | |
Max_Latency(ms): 86 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 12 8 6 5 4 3 2 2 2 1 1 1 1 1 1 1 2 2 2 2 3 3 3 3 28 | |
SQLIO: 64kB Random Read for 5x30 minutes | |
2013-11-18 23:25:48 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 133460.36 | |
MBs/sec: 8341.27 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 39 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 7 52 39 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 133308.94 | |
MBs/sec: 8331.80 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 42 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 7 52 38 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 133332.21 | |
MBs/sec: 8333.26 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 40 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 7 52 38 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 133275.15 | |
MBs/sec: 8329.69 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 42 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 7 52 38 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 133287.25 | |
MBs/sec: 8330.45 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 40 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 7 52 38 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 64kB Sequential Write for 5x30 minutes | |
2013-11-19 01:56:48 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 27501.68 | |
MBs/sec: 1718.85 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 13 | |
Max_Latency(ms): 82 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 12 8 5 4 3 3 2 2 1 1 1 1 1 2 2 2 3 3 4 4 4 4 4 4 19 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 48730.01 | |
MBs/sec: 3045.62 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 7 | |
Max_Latency(ms): 145 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 9 9 7 6 6 8 11 9 5 3 3 2 2 2 2 2 2 2 2 2 1 1 1 1 2 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 63624.67 | |
MBs/sec: 3976.54 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 5 | |
Max_Latency(ms): 100 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 8 9 8 7 7 10 14 13 9 4 2 2 2 1 1 1 1 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 70840.82 | |
MBs/sec: 4427.55 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 4 | |
Max_Latency(ms): 74 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 6 9 7 8 8 14 19 16 9 2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads writing for 1800 secs to files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 71297.45 | |
MBs/sec: 4456.09 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 4 | |
Max_Latency(ms): 47 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 6 9 8 8 8 12 18 15 11 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 64kB Sequential Read for 5x30 minutes | |
2013-11-19 04:27:48 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 132708.80 | |
MBs/sec: 8294.30 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 145 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 66 32 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 132173.89 | |
MBs/sec: 8260.86 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 40 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 64 34 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 132006.26 | |
MBs/sec: 8250.39 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 39 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 64 35 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 132015.59 | |
MBs/sec: 8250.97 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 44 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 64 35 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2922646 counts per second | |
parameter file used: C:\Users\Administrator\Documents\OnTarget\SQLIO\mach4_64thread.txt | |
file D:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
file E:\iobw.tst with 64 threads (64-127) using mask 0x0 (0) | |
file F:\iobw.tst with 64 threads (128-191) using mask 0x0 (0) | |
192 threads reading for 1800 secs from files D:\iobw.tst, E:\iobw.tst and F:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 2359296 MB for file: D:\iobw.tst | |
using specified size: 2359296 MB for file: E:\iobw.tst | |
using specified size: 2359296 MB for file: F:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 131952.76 | |
MBs/sec: 8247.04 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 42 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 63 35 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: done | |
2013-11-19 06:57:48 |