Overview

SQLIO on SMB3
Client1
Client2
Client3


Sheet 1: SQLIO on SMB3

MS SQLIO Tests of ION SR-71mach4







Server is ION SR-71mach4 with (3) 4TB RAID 5 shares, (3) X520-DA2 dual 10GbE NICs







3 Clients, each with dual E5 2690 Xeon processors and X520-DA2 dual 10GBE NICs.







Each client used one shared 4TB file.







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







Detailed output from tests on each client are on the other 3 tabs in this sheet.

















SQLIO: 8kB Random Write for 5x30 minutes







Client 1
Client 2
Client 3
Total Average
Run # IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Latency
1 30,513 3 30,547 3 30,550 3

2 30,502 3 30,524 3 30,527 3

3 30,511 3 30,536 3 30,531 3

4 30,518 3 30,550 3 30,552 3

5 30,508 3 30,529 3 30,525 3

Trimmed Mean 30,511 3 30,537 3 30,537 3 91,585 3







716 Mbps

SQLIO: 8kB Random Read for 5x30 minutes







Client 1
Client 2
Client 3
Total Average
Run # IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Latency
1 222,371 0 224,416 0 226,977 0

2 221,758 0 223,582 0 226,846 0

3 221,895 0 223,299 0 226,927 0

4 221,879 0 224,014 0 226,736 0

5 222,157 0 223,522 0 227,189 0

Trimmed Mean 222,012 0 223,767 0 226,935 0 672,714 0







5,256 Mbps

SQLIO: 8kB Sequential Write for 5x30 minutes







Client 1
Client 2
Client 3
Total Average
Run # IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Latency
1 9,688 12 9,659 12 10,257 11

2 9,689 12 9,674 12 10,289 11

3 9,755 12 9,700 12 10,326 11

4 9,750 12 9,734 12 10,345 11

5 9,860 12 9,829 12 10,422 11

Trimmed Mean 9,749 12 9,719 12 10,328 11 29,796 12







233 Mbps










SQLIO: 8kB Sequential Read for 5x30 minutes







Client 1
Client 2
Client 3
Total Average
Run # IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Latency
1 222,904 0 224,684 0 227,210 0

2 222,757 0 224,874 0 227,304 0

3 222,589 0 224,955 0 227,155 0

4 222,928 0 224,872 0 227,363 0

5 222,901 0 225,277 0 227,289 0

Trimmed Mean 222,816 0 224,932 0 227,264 0 675,013 0







5,274 Mbps










SQLIO: 64kB Random Write for 5x30 minutes







Client 1
Client 2
Client 3
Total Average
Run # IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Latency
1 6,477 19 6,380 19 6,499 19

2 6,156 20 6,148 20 6,281 19

3 6,741 18 6,710 18 6,918 18

4 6,614 18 6,613 18 6,754 18

5 6,504 19 6,463 19 6,720 18

Trimmed Mean 6,498 19 6,463 19 6,634 18 19,596 19







1,225 Mbps

SQLIO: 64kB Random Read for 5x30 minutes







Client 1
Client 2
Client 3
Total Average
Run # IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Latency
1 37,603 2 37,510 2 37,428 2

2 37,575 2 37,491 2 37,414 2

3 37,580 2 37,485 2 37,426 2

4 37,587 2 37,501 2 37,433 2

5 37,593 2 37,484 2 37,419 2

Trimmed Mean 37,588 2 37,494 2 37,424 2 112,506 2







7,032 Mbps

SQLIO: 64kB Sequential Write for 5x30 minutes







Client 1
Client 2
Client 3
Total Average
Run # IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Latency
1 7,173 17 7,159 17 7,233 17

2 8,417 14 8,378 14 8,347 14

3 8,828 13 8,853 13 8,788 14

4 8,782 14 8,774 14 8,878 13

5 9,421 13 9,381 13 9,133 13

Trimmed Mean 8,524 14 8,509 14 8,476 14 25,509 14







1,594 Mbps










SQLIO: 64kB Sequential Read for 5x30 minutes







Client 1
Client 2
Client 3
Total Average
Run # IOPS Ave. Lat. IOPS Ave. Lat. IOPS Ave. Lat. IOPS Latency
1 37,635 2 37,521 2 37,407 2

2 37,638 2 37,517 2 37,438 2

3 37,655 2 37,532 2 37,409 2

4 37,642 2 37,526 2 37,417 2

5 37,645 2 37,528 2 37,420 2

Trimmed Mean 37,643 2 37,525 2 37,418 2 112,586 2







7,037 Mbps

Sheet 2: Client1

SQLIO: 8kB Random Write for 5x30 minutes
2013-11-06 13:53:41


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30512.77
MBs/sec: 238.38
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 158
histogram:
ms: 0 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 5 48 29 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30502.42
MBs/sec: 238.30
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
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+
%: 0 0 5 48 29 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30510.97
MBs/sec: 238.36
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 0 5 48 29 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30518.28
MBs/sec: 238.42
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 59
histogram:
ms: 0 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 5 48 29 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30508.09
MBs/sec: 238.34
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 5 48 29 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
2013-11-06 16:24:42


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 222371.24
MBs/sec: 1737.27
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 8
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 221757.84
MBs/sec: 1732.48
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+
%: 98 2 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 221894.77
MBs/sec: 1733.55
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+
%: 98 2 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 221879.05
MBs/sec: 1733.43
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 18
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 222157.48
MBs/sec: 1735.60
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 16
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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-06 18:55:42


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9688.15
MBs/sec: 75.68
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 12
Max_Latency(ms): 220
histogram:
ms: 0 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 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9689.19
MBs/sec: 75.69
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 12
Max_Latency(ms): 218
histogram:
ms: 0 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 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9755.23
MBs/sec: 76.21
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 12
Max_Latency(ms): 219
histogram:
ms: 0 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 4 5 4 5 5 5 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9750.11
MBs/sec: 76.17
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 12
Max_Latency(ms): 237
histogram:
ms: 0 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 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9860.16
MBs/sec: 77.03
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 12
Max_Latency(ms): 219
histogram:
ms: 0 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 4 5 4 5 5 5 4 4 4 4 3 3 3 3 3 3 3 2 2 2 2 2 2 15


SQLIO: 8kB Sequential Read for 5x30 minutes
2013-11-06 21:26:42


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 222904.36
MBs/sec: 1741.44
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+
%: 98 2 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 222756.76
MBs/sec: 1740.28
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 16
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 222589.17
MBs/sec: 1738.97
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+
%: 98 2 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 222928.32
MBs/sec: 1741.62
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 19
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 222900.92
MBs/sec: 1741.41
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 18
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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-06 23:57:42


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6476.90
MBs/sec: 404.80
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 19
Max_Latency(ms): 185
histogram:
ms: 0 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 1 2 3 4 4 4 4 4 4 4 4 4 4 3 3 3 3 2 2 2 2 2 29
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6155.68
MBs/sec: 384.73
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 20
Max_Latency(ms): 227
histogram:
ms: 0 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 2 3 5 5 5 5 4 4 4 4 3 3 3 3 3 2 2 2 2 2 2 2 31
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6741.18
MBs/sec: 421.32
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 18
Max_Latency(ms): 163
histogram:
ms: 0 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 4 3 3 3 2 2 2 2 2 1 1 1 1 27
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6614.04
MBs/sec: 413.37
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 18
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 1 3 5 6 6 6 5 5 4 4 4 3 3 3 2 2 2 2 2 2 1 1 1 28
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6503.79
MBs/sec: 406.48
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 1 3 5 6 6 6 5 5 4 4 3 3 3 3 2 2 2 2 2 2 2 1 1 28


SQLIO: 64kB Random Read for 5x30 minutes
2013-11-07 02:28:42


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37603.15
MBs/sec: 2350.19
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 5575
histogram:
ms: 0 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 27 41 20 6 2 1 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37575.06
MBs/sec: 2348.44
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 5526
histogram:
ms: 0 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 28 41 20 6 2 1 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37580.25
MBs/sec: 2348.76
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3327
histogram:
ms: 0 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 28 41 20 6 2 1 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37587.00
MBs/sec: 2349.18
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 4493
histogram:
ms: 0 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 28 41 20 6 2 1 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37593.49
MBs/sec: 2349.59
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 6631
histogram:
ms: 0 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 28 41 20 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1


SQLIO: 64kB Sequential Write for 5x30 minutes
2013-11-07 04:59:43


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 7173.22
MBs/sec: 448.32
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 17
Max_Latency(ms): 177
histogram:
ms: 0 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 5 6 5 4 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 2 29
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 8417.11
MBs/sec: 526.06
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 14
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 3 5 5 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 20
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 8828.21
MBs/sec: 551.76
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 13
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 4 5 6 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 17
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 8781.76
MBs/sec: 548.86
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 14
Max_Latency(ms): 179
histogram:
ms: 0 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 4 5 6 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 18
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9420.94
MBs/sec: 588.80
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 13
Max_Latency(ms): 209
histogram:
ms: 0 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 6 5 5 4 4 4 4 4 4 4 4 4 4 3 3 3 3 3 3 2 2 2 14


SQLIO: 64kB Sequential Read for 5x30 minutes
2013-11-07 07:30:43


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37635.20
MBs/sec: 2352.20
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3023
histogram:
ms: 0 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 30 42 17 6 2 1 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37638.19
MBs/sec: 2352.38
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3290
histogram:
ms: 0 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 30 42 17 6 2 1 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37654.72
MBs/sec: 2353.42
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 4510
histogram:
ms: 0 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 29 43 17 6 2 1 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37641.74
MBs/sec: 2352.60
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 6641
histogram:
ms: 0 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 30 43 17 6 2 1 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37645.22
MBs/sec: 2352.82
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3937
histogram:
ms: 0 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 29 43 17 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1


SQLIO: done
2013-11-07 10:00:43

Sheet 3: Client2

SQLIO: 8kB Random Write for 5x30 minutes
2013-11-06 13:53:43


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30547.46
MBs/sec: 238.65
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 64
histogram:
ms: 0 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 5 48 29 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30524.31
MBs/sec: 238.47
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 66
histogram:
ms: 0 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 5 48 28 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30536.35
MBs/sec: 238.56
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
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 0 5 48 28 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30550.24
MBs/sec: 238.67
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 54
histogram:
ms: 0 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 5 48 29 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30528.73
MBs/sec: 238.50
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 53
histogram:
ms: 0 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 5 48 28 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
2013-11-06 16:24:43


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 224416.38
MBs/sec: 1753.25
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 8
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 99 1 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 223582.23
MBs/sec: 1746.73
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 142
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 1 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 223299.49
MBs/sec: 1744.52
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 16
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 1 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 224013.54
MBs/sec: 1750.10
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+
%: 99 1 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 223522.21
MBs/sec: 1746.26
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 16
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 1 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-06 18:55:43


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9658.75
MBs/sec: 75.45
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 12
Max_Latency(ms): 236
histogram:
ms: 0 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 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 16
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9674.31
MBs/sec: 75.58
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 12
Max_Latency(ms): 225
histogram:
ms: 0 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 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9700.36
MBs/sec: 75.78
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 12
Max_Latency(ms): 231
histogram:
ms: 0 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 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9733.60
MBs/sec: 76.04
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 12
Max_Latency(ms): 242
histogram:
ms: 0 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 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9829.41
MBs/sec: 76.79
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 12
Max_Latency(ms): 231
histogram:
ms: 0 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 4 5 4 5 5 5 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15


SQLIO: 8kB Sequential Read for 5x30 minutes
2013-11-06 21:26:43


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 224683.99
MBs/sec: 1755.34
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 18
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 224873.94
MBs/sec: 1756.82
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+
%: 98 2 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 224955.10
MBs/sec: 1757.46
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 13
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 224871.81
MBs/sec: 1756.81
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 19
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 225276.63
MBs/sec: 1759.97
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 13
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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-06 23:57:43


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6380.03
MBs/sec: 398.75
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 0 1 3 4 4 5 5 4 4 4 4 4 4 3 3 3 3 2 2 2 2 2 2 29
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6147.81
MBs/sec: 384.23
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 20
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 0 2 3 5 5 5 5 4 4 4 4 3 3 3 3 3 2 2 2 2 2 2 2 31
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6710.36
MBs/sec: 419.39
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 18
Max_Latency(ms): 160
histogram:
ms: 0 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 4 3 3 3 2 2 2 2 2 1 1 1 1 28
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6613.44
MBs/sec: 413.34
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 18
Max_Latency(ms): 179
histogram:
ms: 0 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 3 2 2 2 2 2 2 2 1 1 29
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6463.22
MBs/sec: 403.95
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 19
Max_Latency(ms): 189
histogram:
ms: 0 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 3 2 2 2 2 2 2 1 1 1 29


SQLIO: 64kB Random Read for 5x30 minutes
2013-11-07 02:28:43


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37510.04
MBs/sec: 2344.37
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3067
histogram:
ms: 0 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 26 41 22 7 2 0 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37491.27
MBs/sec: 2343.20
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 2458
histogram:
ms: 0 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 26 41 22 7 2 0 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37484.55
MBs/sec: 2342.78
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 4525
histogram:
ms: 0 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 27 41 21 7 2 0 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37500.71
MBs/sec: 2343.79
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 4527
histogram:
ms: 0 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 26 41 22 7 2 0 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37483.53
MBs/sec: 2342.72
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3043
histogram:
ms: 0 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 27 41 21 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1


SQLIO: 64kB Sequential Write for 5x30 minutes
2013-11-07 04:59:43


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 7158.92
MBs/sec: 447.43
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 17
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 2 5 6 5 4 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 2 29
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 8377.89
MBs/sec: 523.61
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 14
Max_Latency(ms): 183
histogram:
ms: 0 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 5 5 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 20
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 8853.25
MBs/sec: 553.32
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 13
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 4 5 6 5 4 4 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 2 2 17
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 8773.92
MBs/sec: 548.37
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 14
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+
%: 0 4 5 6 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 18
sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9380.96
MBs/sec: 586.31
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 13
Max_Latency(ms): 179
histogram:
ms: 0 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 6 5 5 4 4 4 4 4 4 4 4 4 4 3 3 3 3 3 3 2 2 2 15


SQLIO: 64kB Sequential Read for 5x30 minutes
2013-11-07 07:30:43


sqlio v1.5.SG
using system counter for latency timings, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37520.82
MBs/sec: 2345.05
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3021
histogram:
ms: 0 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 29 40 20 7 2 0 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37516.85
MBs/sec: 2344.80
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3952
histogram:
ms: 0 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 29 40 20 7 2 0 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37531.81
MBs/sec: 2345.73
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3042
histogram:
ms: 0 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 28 40 20 7 2 0 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37525.82
MBs/sec: 2345.36
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3010
histogram:
ms: 0 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 29 40 20 7 2 0 0 0 0 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, 2825227 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37528.49
MBs/sec: 2345.53
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 4600
histogram:
ms: 0 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 28 40 20 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1


SQLIO: done
2013-11-07 10:00:44

Sheet 4: Client3

SQLIO: 8kB Random Write for 5x30 minutes
2013-11-06 13:53:41


sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30549.96
MBs/sec: 238.67
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 68
histogram:
ms: 0 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 5 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30526.56
MBs/sec: 238.48
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 5 47 29 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30531.46
MBs/sec: 238.52
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 5 47 29 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30551.86
MBs/sec: 238.68
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 5 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 30525.38
MBs/sec: 238.47
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 3
Max_Latency(ms): 79
histogram:
ms: 0 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 5 47 29 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
2013-11-06 16:24:41


sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 226977.14
MBs/sec: 1773.25
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 9
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 226846.22
MBs/sec: 1772.23
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+
%: 98 2 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 226926.87
MBs/sec: 1772.86
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 18
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 226735.98
MBs/sec: 1771.37
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 19
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 227188.98
MBs/sec: 1774.91
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 18
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 2 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-06 18:55:41


sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 10256.92
MBs/sec: 80.13
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 11
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+
%: 10 4 6 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 14
sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 10289.00
MBs/sec: 80.38
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 11
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+
%: 10 4 6 4 5 5 5 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 14
sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 10325.92
MBs/sec: 80.67
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 11
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+
%: 10 4 6 4 5 5 5 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 14
sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 10345.04
MBs/sec: 80.82
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 11
Max_Latency(ms): 147
histogram:
ms: 0 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 4 6 4 5 5 5 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 14
sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 10421.78
MBs/sec: 81.42
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 11
Max_Latency(ms): 143
histogram:
ms: 0 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 4 6 4 5 5 5 4 4 4 4 3 3 3 3 3 3 3 2 2 2 2 2 2 14


SQLIO: 8kB Sequential Read for 5x30 minutes
2013-11-06 21:26:41


sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 227210.47
MBs/sec: 1775.08
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+
%: 97 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 v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 227304.30
MBs/sec: 1775.81
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 15
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 97 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 v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 227155.01
MBs/sec: 1774.64
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 15
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 97 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 v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 227363.36
MBs/sec: 1776.27
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 15
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 97 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 v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 227289.21
MBs/sec: 1775.69
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+
%: 97 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: 64kB Random Write for 5x30 minutes
2013-11-06 23:57:41


sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6499.21
MBs/sec: 406.20
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 19
Max_Latency(ms): 169
histogram:
ms: 0 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 1 2 3 4 4 4 4 4 4 4 4 4 3 3 3 3 3 3 2 2 2 2 30
sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6280.91
MBs/sec: 392.55
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 19
Max_Latency(ms): 186
histogram:
ms: 0 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 6 5 5 4 4 4 4 3 3 3 3 2 2 2 2 2 2 2 2 29
sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6917.85
MBs/sec: 432.36
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 18
Max_Latency(ms): 176
histogram:
ms: 0 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 4 3 3 3 2 2 2 2 2 2 2 1 1 27
sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6754.04
MBs/sec: 422.12
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 18
Max_Latency(ms): 209
histogram:
ms: 0 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 5 5 5 4 4 3 3 3 3 2 2 2 2 2 2 2 2 1 28
sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6719.59
MBs/sec: 419.97
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 18
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 1 3 5 6 6 6 5 5 4 4 3 3 3 3 2 2 2 2 2 2 2 2 1 27


SQLIO: 64kB Random Read for 5x30 minutes
2013-11-07 02:28:41


sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37428.47
MBs/sec: 2339.27
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 2786
histogram:
ms: 0 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 24 42 23 7 2 0 0 0 0 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37414.23
MBs/sec: 2338.38
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3614
histogram:
ms: 0 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 24 42 22 7 2 0 0 0 0 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37426.45
MBs/sec: 2339.15
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3648
histogram:
ms: 0 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 24 42 22 7 2 0 0 0 0 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37433.32
MBs/sec: 2339.58
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 4612
histogram:
ms: 0 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 24 42 23 7 2 0 0 0 0 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37418.90
MBs/sec: 2338.68
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 4829
histogram:
ms: 0 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 24 42 22 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1


SQLIO: 64kB Sequential Write for 5x30 minutes
2013-11-07 04:59:42


sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 7232.86
MBs/sec: 452.05
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 17
Max_Latency(ms): 177
histogram:
ms: 0 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 5 4 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 2 28
sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 8347.27
MBs/sec: 521.70
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 14
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 3 5 5 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 20
sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 8787.79
MBs/sec: 549.23
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 14
Max_Latency(ms): 198
histogram:
ms: 0 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 4 5 6 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 18
sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 8878.00
MBs/sec: 554.87
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 13
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 4 5 6 5 4 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 17
sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads writing for 1800 secs to file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 9133.49
MBs/sec: 570.84
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 13
Max_Latency(ms): 204
histogram:
ms: 0 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 6 5 5 4 4 4 4 4 4 4 4 4 4 3 3 3 3 3 3 2 2 2 16


SQLIO: 64kB Sequential Read for 5x30 minutes
2013-11-07 07:30:42


sqlio v1.5.SG
using system counter for latency timings, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37406.66
MBs/sec: 2337.91
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 9628
histogram:
ms: 0 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 24 45 21 6 2 0 0 0 0 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37437.73
MBs/sec: 2339.85
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 5475
histogram:
ms: 0 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 22 46 22 6 2 0 0 0 0 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37408.79
MBs/sec: 2338.04
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 4315
histogram:
ms: 0 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 23 45 21 6 2 0 0 0 0 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37417.32
MBs/sec: 2338.58
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 4868
histogram:
ms: 0 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 23 45 21 6 2 0 0 0 0 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, 2825229 counts per second
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt

file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0)
64 threads reading for 1800 secs from file M:\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: M:\iobw.tst
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 37419.60
MBs/sec: 2338.72
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 3037
histogram:
ms: 0 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 23 46 22 6 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1


SQLIO: done
2013-11-07 10:00:43