Overview

SQLIO on SMB3
Client1
Client2
Client3
Client4
Client5


Sheet 1: SQLIO on SMB3

MS SQLIO Tests of ION SR-71mach5 file server











Windows Server 2012 R2 on ION SR-71mach5 with (12) 1TB RAID 5 shares, (5) Intel dual 10GbE NICs











5 Clients, each with dual E5 2690 Xeon processors and dual Intel 10GBE NICs.











Each client used two 800GB files, each on a separate share..











Tests were started simultaneously. 1min rest between each set of 5.











Detailed output from tests on each client follow..
























SQLIO: 8kB Random Write for 5x30 minutes












Total Average Client 1
Client 2
Client 3
Client 4
Client 5
Run # IOPS Latency IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat.
1

23,719 3 18,889 4 25,379 3 22,997 3 19,137 4
2

24,230 3 19,302 4 26,017 3 23,910 3 19,519 4
3

23,820 3 19,481 4 25,793 3 23,662 3 19,601 4
4

24,215 3 19,543 4 26,184 3 23,896 3 19,760 4
5

23,820 3 19,481 4 25,793 3 23,662 3 19,601 4
Trimmed Mean 112,282 3 23,961 3 19,339 4 25,833 3 23,626 3 19,524 4

877 Mbps









SQLIO: 8kB Random Read for 5x30 minutes












Total Average Client 1
Client 2
Client 3
Client 4
Client 5
Run # IOPS Latency IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat.
1

181,955 0 175,735 0 198,044 0 180,785 0 191,098 0
2

181,372 0 175,381 0 197,111 0 180,150 0 190,530 0
3

181,170 0 176,606 0 196,650 0 182,191 0 190,156 0
4

181,221 0 176,111 0 197,413 0 179,530 0 190,369 0
5

181,535 0 177,466 0 197,069 0 181,860 0 190,114 0
Trimmed Mean 926,324 0 181,451 0 176,260 0 197,257 0 180,903 0 190,453 0

7,237 Mbps









SQLIO: 64kB Random Write for 5x30 minutes












Total Average Client 1
Client 2
Client 3
Client 4
Client 5
Run # IOPS Latency IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat.
1

3,830 49 3,415 55 4,332 43 3,742 50 3,435 55
2

3,809 49 3,390 56 4,289 44 3,819 49 3,398 55
3

3,886 48 3,526 53 4,428 42 3,889 48 3,533 53
4

3,940 48 3,565 53 4,466 42 3,946 48 3,571 53
5

3,944 48 3,669 51 4,507 42 4,008 47 3,645 52
Trimmed Mean 19,196 49 3,882 48 3,513 54 4,404 43 3,881 48 3,517 54

1,200 Mbps






















SQLIO: 64kB Random Read for 5x30 minutes












Total Average Client 1
Client 2
Client 3
Client 4
Client 5
Run # IOPS Latency IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat.
1

32,729 5 32,346 5 35,138 4 32,835 5 29,403 6
2

32,680 5 32,342 5 35,079 4 32,819 5 29,033 6
3

32,652 5 32,366 5 35,086 4 32,787 5 28,992 6
4

32,542 5 32,293 5 35,120 4 32,681 5 29,258 6
5

32,624 5 32,360 5 35,084 4 32,799 5 29,018 6
Trimmed Mean 162,013 5 32,645 5 32,342 5 35,101 4 32,784 5 29,141 6

10,126 Mbps










Sheet 2: Client1

Client 1
SQLIO: 8kB Random Write for 5x30 minutes
2015-02-25 22:19:01


sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 23718.62
MBs/sec: 185.30
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 99
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 12 25 21 16 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 24230.48
MBs/sec: 189.30
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 170
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 11 28 22 16 10 6 3 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 24516.26
MBs/sec: 191.53
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 108
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 11 28 22 15 10 6 3 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 24214.72
MBs/sec: 189.17
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 131
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 11 27 22 16 10 6 3 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 23819.94
MBs/sec: 186.09
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+
%: 0 11 27 22 16 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0


SQLIO: 8kB Random Read for 5x30 minutes
2015-02-26 00:50:02


sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 181954.80
MBs/sec: 1421.52
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 470
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 52 1 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, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 181372.29
MBs/sec: 1416.97
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 31
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 52 1 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, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 181170.29
MBs/sec: 1415.39
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+
%: 46 53 1 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, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 181221.43
MBs/sec: 1415.79
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 27
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 52 1 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, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 181534.79
MBs/sec: 1418.24
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 27
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 52 1 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
2015-02-26 03:21:02


sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3829.90
MBs/sec: 239.36
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 49
Max_Latency(ms): 329
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 0 0 0 0 1 2 2 3 3 3 3 2 2 2 2 2 2 1 1 1 1 1 65
sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3809.13
MBs/sec: 238.07
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 49
Max_Latency(ms): 306
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 0 0 0 0 1 2 3 4 3 3 3 2 2 2 2 1 1 1 1 1 1 1 65
sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3886.14
MBs/sec: 242.88
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 48
Max_Latency(ms): 310
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 0 0 0 0 1 2 3 3 3 3 3 2 2 2 2 1 1 1 1 1 1 1 65
sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3939.67
MBs/sec: 246.22
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 48
Max_Latency(ms): 303
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 0 0 0 0 1 2 3 4 3 3 3 2 2 2 2 1 1 1 1 1 1 1 64
sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3943.54
MBs/sec: 246.47
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 48
Max_Latency(ms): 322
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 0 0 0 0 1 3 4 4 4 3 3 2 2 2 2 1 1 1 1 1 1 1 64


SQLIO: 64kB Random Read for 5x30 minutes
2015-02-26 05:52:08


sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32729.40
MBs/sec: 2045.58
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 2455
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 8 15 18 17 13 10 7 5 3 2 1 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32679.75
MBs/sec: 2042.48
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 919
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 7 15 19 17 13 10 7 4 3 2 1 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32651.66
MBs/sec: 2040.72
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 932
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 7 15 19 17 14 10 7 5 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32541.89
MBs/sec: 2033.86
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 917
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 7 14 19 18 14 10 7 5 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825223 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32623.86
MBs/sec: 2038.99
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 929
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 7 15 19 17 14 10 7 5 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0

Sheet 3: Client2

Client 2
SQLIO: 8kB Random Write for 5x30 minutes
2015-02-25 22:19:25


sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 18889.44
MBs/sec: 147.57
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 97
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 6 14 18 18 15 11 7 4 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, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 19301.62
MBs/sec: 150.79
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 305
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 5 14 19 19 16 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 19574.25
MBs/sec: 152.92
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 311
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 5 15 19 19 16 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 19543.13
MBs/sec: 152.68
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 115
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 5 15 19 19 15 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 19480.57
MBs/sec: 152.19
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 146
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 6 15 19 18 15 10 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0


SQLIO: 8kB Random Read for 5x30 minutes
2015-02-26 00:50:25


sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 175735.18
MBs/sec: 1372.93
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 472
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+
%: 41 58 1 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, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 175381.25
MBs/sec: 1370.16
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
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+
%: 41 58 1 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, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 176606.48
MBs/sec: 1379.73
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+
%: 42 57 1 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, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 176110.53
MBs/sec: 1375.86
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
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+
%: 41 57 1 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, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 177465.69
MBs/sec: 1386.45
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 37
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+
%: 42 56 1 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
2015-02-26 03:21:25


sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3415.36
MBs/sec: 213.46
latency metrics:
Min_Latency(ms): 2
Avg_Latency(ms): 55
Max_Latency(ms): 257
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 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 81
sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3390.03
MBs/sec: 211.87
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 56
Max_Latency(ms): 272
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 0 0 0 0 0 0 0 1 1 1 2 2 2 1 1 1 1 1 1 1 1 1 81
sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3525.99
MBs/sec: 220.37
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 53
Max_Latency(ms): 286
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 0 0 0 0 0 0 1 1 1 2 2 2 2 2 1 1 1 1 1 1 1 1 79
sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3565.23
MBs/sec: 222.82
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 53
Max_Latency(ms): 256
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 0 0 0 0 0 0 1 1 2 2 2 2 2 2 1 1 1 1 1 1 1 1 78
sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3668.66
MBs/sec: 229.29
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 51
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+
%: 0 0 0 0 0 0 0 0 1 1 1 2 2 2 2 2 1 1 1 1 1 1 1 1 79


SQLIO: 64kB Random Read for 5x30 minutes
2015-02-26 05:52:38


sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32346.27
MBs/sec: 2021.64
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 933
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 14 20 19 15 10 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32342.20
MBs/sec: 2021.38
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 3317
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 15 20 19 14 10 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32366.27
MBs/sec: 2022.89
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 2414
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 5 14 20 19 15 10 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32292.81
MBs/sec: 2018.30
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 966
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 5 14 20 20 15 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825219 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32360.49
MBs/sec: 2022.53
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 929
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 5 14 20 19 15 10 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0

Sheet 4: Client3

Client 3
SQLIO: 8kB Random Write for 5x30 minutes
2015-02-25 19:19:05


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 25379.17
MBs/sec: 198.27
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 89
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 28 22 15 9 5 3 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 26016.88
MBs/sec: 203.25
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
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+
%: 0 12 31 24 15 8 4 2 1 1 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, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 26438.52
MBs/sec: 206.55
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 132
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 13 31 24 15 8 4 2 1 1 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, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 26183.62
MBs/sec: 204.55
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 96
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 12 31 24 15 8 4 2 1 1 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, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 25792.80
MBs/sec: 201.50
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
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+
%: 0 12 30 23 15 8 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0


SQLIO: 8kB Random Read for 5x30 minutes
2015-02-25 21:50:05


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 198043.51
MBs/sec: 1547.21
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 103
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+
%: 57 43 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, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 197110.61
MBs/sec: 1539.92
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+
%: 57 43 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, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 196650.47
MBs/sec: 1536.33
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
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+
%: 56 44 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, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 197413.08
MBs/sec: 1542.28
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 37
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+
%: 57 43 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, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 197069.24
MBs/sec: 1539.60
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+
%: 56 44 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
2015-02-26 00:21:05


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 4331.58
MBs/sec: 270.72
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 43
Max_Latency(ms): 298
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 0 0 0 0 1 1 2 3 3 4 3 3 3 3 3 3 2 2 2 2 2 2 55
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 4289.43
MBs/sec: 268.08
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 44
Max_Latency(ms): 395
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 0 0 0 0 1 2 3 4 4 4 4 3 3 3 3 2 2 2 2 2 1 1 54
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 4428.12
MBs/sec: 276.75
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 42
Max_Latency(ms): 313
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 0 0 0 0 1 2 3 4 4 4 4 3 3 3 3 2 2 2 2 2 1 1 53
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 4465.96
MBs/sec: 279.12
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 42
Max_Latency(ms): 313
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 0 0 0 0 1 2 4 4 4 4 4 4 3 3 3 2 2 2 2 2 1 1 52
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 4506.50
MBs/sec: 281.65
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 42
Max_Latency(ms): 314
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 0 0 0 0 1 3 4 4 4 4 4 3 3 3 2 2 2 2 2 1 1 1 53


SQLIO: 64kB Random Read for 5x30 minutes
2015-02-26 02:52:05


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 35137.58
MBs/sec: 2196.09
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 666
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 10 20 22 17 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 35079.01
MBs/sec: 2192.43
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 330
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 9 20 23 18 12 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 35086.11
MBs/sec: 2192.88
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 300
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 9 20 23 18 12 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 35120.39
MBs/sec: 2195.02
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 194
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 8 20 23 18 12 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 35084.31
MBs/sec: 2192.76
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 321
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 9 20 23 18 12 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1

Sheet 5: Client4

Client 4
SQLIO: 8kB Random Write for 5x30 minutes
2015-02-25 22:19:19


sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 22997.15
MBs/sec: 179.66
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 96
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 11 25 21 15 10 6 4 2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 23909.97
MBs/sec: 186.79
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 170
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 11 28 22 15 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 24183.98
MBs/sec: 188.93
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 132
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 11 28 22 15 9 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 23895.97
MBs/sec: 186.68
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 115
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 11 27 22 15 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 23662.39
MBs/sec: 184.86
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 98
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 27 21 15 9 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0


SQLIO: 8kB Random Read for 5x30 minutes
2015-02-26 00:50:19


sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 180784.79
MBs/sec: 1412.38
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 217
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 53 1 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, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 180149.80
MBs/sec: 1407.42
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 37
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 53 1 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, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 182190.99
MBs/sec: 1423.36
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 33
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 52 1 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, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 179529.52
MBs/sec: 1402.57
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
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+
%: 45 54 1 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, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 181859.91
MBs/sec: 1420.78
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 35
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 52 1 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
2015-02-26 03:21:19


sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3741.74
MBs/sec: 233.85
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 50
Max_Latency(ms): 331
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 0 0 0 0 1 1 2 3 3 3 3 2 2 2 2 2 2 1 1 1 1 1 67
sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3819.44
MBs/sec: 238.71
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 49
Max_Latency(ms): 322
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 0 0 0 0 1 2 3 4 3 3 3 2 2 2 2 1 1 1 1 1 1 1 65
sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3888.50
MBs/sec: 243.03
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 48
Max_Latency(ms): 309
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 0 0 0 0 1 2 3 3 3 3 3 2 2 2 2 1 1 1 1 1 1 1 65
sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3946.26
MBs/sec: 246.64
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 48
Max_Latency(ms): 308
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 0 0 0 0 1 2 3 4 3 3 3 2 2 2 2 1 1 1 1 1 1 1 64
sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 4007.69
MBs/sec: 250.48
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 47
Max_Latency(ms): 290
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 0 0 0 0 1 3 4 4 4 3 3 2 2 2 2 1 1 1 1 1 1 1 63


SQLIO: 64kB Random Read for 5x30 minutes
2015-02-26 05:52:19


sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32834.55
MBs/sec: 2052.15
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 649
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 8 15 19 17 13 10 7 5 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32818.74
MBs/sec: 2051.17
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
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 7 15 19 17 13 10 7 4 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32786.73
MBs/sec: 2049.17
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 361
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 7 15 19 18 14 10 7 4 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32681.45
MBs/sec: 2042.59
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 226
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 14 19 18 14 10 7 4 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 2143276 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 32798.61
MBs/sec: 2049.91
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 370
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 7 15 19 17 14 10 7 4 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0

Sheet 6: Client5

Client 5
SQLIO: 8kB Random Write for 5x30 minutes
2015-02-26 03:21:41


sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 19136.99
MBs/sec: 149.50
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 111
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 6 15 18 18 15 10 7 4 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, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 19519.29
MBs/sec: 152.49
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 173
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 6 15 19 19 15 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 19798.64
MBs/sec: 154.67
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 108
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 6 15 19 19 15 11 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 19759.83
MBs/sec: 154.37
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 114
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 6 15 19 19 15 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 4 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 19600.97
MBs/sec: 153.13
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 133
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 6 15 19 18 15 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0


SQLIO: 8kB Random Read for 5x30 minutes
2015-02-26 05:52:41


sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 191097.92
MBs/sec: 1492.95
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 406
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+
%: 62 35 3 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, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 190530.03
MBs/sec: 1488.51
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
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+
%: 62 35 3 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, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 190156.02
MBs/sec: 1485.59
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 35
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+
%: 62 35 3 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, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 190369.22
MBs/sec: 1487.25
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
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+
%: 62 36 3 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, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 8KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 190113.92
MBs/sec: 1485.26
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+
%: 62 35 3 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
2015-02-26 08:23:41


sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3435.08
MBs/sec: 214.69
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 55
Max_Latency(ms): 272
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 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 81
sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3398.09
MBs/sec: 212.38
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 55
Max_Latency(ms): 4519
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 0 0 0 0 0 0 1 1 1 1 2 2 2 1 1 1 1 1 1 1 1 1 81
sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3533.28
MBs/sec: 220.83
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 53
Max_Latency(ms): 268
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 0 0 0 0 0 0 1 1 1 2 2 2 2 2 1 1 1 1 1 1 1 1 79
sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3571.18
MBs/sec: 223.19
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 53
Max_Latency(ms): 5734
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 0 0 0 0 0 0 1 1 2 2 2 2 2 2 1 1 1 1 1 1 1 1 78
sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3645.45
MBs/sec: 227.84
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 52
Max_Latency(ms): 255
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 0 0 0 0 0 0 1 1 1 2 2 2 2 1 1 1 1 1 1 1 1 1 79


SQLIO: 64kB Random Read for 5x30 minutes
2015-02-26 10:54:41


sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 29402.77
MBs/sec: 1837.67
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 6
Max_Latency(ms): 253
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 10 15 17 16 14 10 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 29032.54
MBs/sec: 1814.53
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 6
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 0 4 10 15 16 15 14 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 28992.34
MBs/sec: 1812.02
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 6
Max_Latency(ms): 167
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 9 14 16 16 14 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 29258.41
MBs/sec: 1828.65
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 6
Max_Latency(ms): 276
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 9 15 17 16 14 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0
sqlio v1.5.SG
using system counter for latency timings, 3214909 counts per second
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt

file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0)

file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0)
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst

using 64KB random IOs

enabling multiple I/Os per thread with 8 outstanding

buffering set to not use file nor disk caches (as is SQL Server)
using specified size: 819200 MB for file: D:\iobw.tst
using specified size: 819200 MB for file: E:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 29017.76
MBs/sec: 1813.61
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 6
Max_Latency(ms): 416
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 4 9 14 16 16 14 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0