Overview

SQLIO on Target
RAID 5
RAID 10


Sheet 1: SQLIO on Target

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

Sheet 2: RAID 5

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

Sheet 3: RAID 10

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