Client 1 |
|
SQLIO: 8kB Random Write for 5x30 minutes |
|
2015-02-25 22:19:01 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 23718.62 |
|
MBs/sec: 185.30 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 99 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 1 12 25 21 16 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 24230.48 |
|
MBs/sec: 189.30 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 170 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 11 28 22 16 10 6 3 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 24516.26 |
|
MBs/sec: 191.53 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 108 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 11 28 22 15 10 6 3 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 24214.72 |
|
MBs/sec: 189.17 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 131 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 11 27 22 16 10 6 3 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 23819.94 |
|
MBs/sec: 186.09 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 95 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 11 27 22 16 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
|
|
SQLIO: 8kB Random Read for 5x30 minutes |
|
2015-02-26 00:50:02 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 181954.80 |
|
MBs/sec: 1421.52 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 470 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 47 52 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 181372.29 |
|
MBs/sec: 1416.97 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 31 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 47 52 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 181170.29 |
|
MBs/sec: 1415.39 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 29 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 46 53 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 181221.43 |
|
MBs/sec: 1415.79 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 27 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 47 52 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 181534.79 |
|
MBs/sec: 1418.24 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 27 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 47 52 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
|
|
SQLIO: 64kB Random Write for 5x30 minutes |
|
2015-02-26 03:21:02 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3829.90 |
|
MBs/sec: 239.36 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 49 |
|
Max_Latency(ms): 329 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 2 2 3 3 3 3 2 2 2 2 2 2 1 1 1 1 1 65 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3809.13 |
|
MBs/sec: 238.07 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 49 |
|
Max_Latency(ms): 306 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 2 3 4 3 3 3 2 2 2 2 1 1 1 1 1 1 1 65 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3886.14 |
|
MBs/sec: 242.88 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 48 |
|
Max_Latency(ms): 310 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 2 3 3 3 3 3 2 2 2 2 1 1 1 1 1 1 1 65 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3939.67 |
|
MBs/sec: 246.22 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 48 |
|
Max_Latency(ms): 303 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 2 3 4 3 3 3 2 2 2 2 1 1 1 1 1 1 1 64 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3943.54 |
|
MBs/sec: 246.47 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 48 |
|
Max_Latency(ms): 322 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 3 4 4 4 3 3 2 2 2 2 1 1 1 1 1 1 1 64 |
|
|
|
SQLIO: 64kB Random Read for 5x30 minutes |
|
2015-02-26 05:52:08 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32729.40 |
|
MBs/sec: 2045.58 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 2455 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 2 8 15 18 17 13 10 7 5 3 2 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32679.75 |
|
MBs/sec: 2042.48 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 919 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 7 15 19 17 13 10 7 4 3 2 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32651.66 |
|
MBs/sec: 2040.72 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 932 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 7 15 19 17 14 10 7 5 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32541.89 |
|
MBs/sec: 2033.86 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 917 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 7 14 19 18 14 10 7 5 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825223 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32623.86 |
|
MBs/sec: 2038.99 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 929 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 7 15 19 17 14 10 7 5 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
Client 2 |
|
SQLIO: 8kB Random Write for 5x30 minutes |
|
2015-02-25 22:19:25 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 18889.44 |
|
MBs/sec: 147.57 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 97 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 6 14 18 18 15 11 7 4 2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 19301.62 |
|
MBs/sec: 150.79 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 305 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 5 14 19 19 16 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 19574.25 |
|
MBs/sec: 152.92 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 311 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 5 15 19 19 16 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 19543.13 |
|
MBs/sec: 152.68 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 115 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 5 15 19 19 15 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 19480.57 |
|
MBs/sec: 152.19 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 146 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 6 15 19 18 15 10 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
|
|
SQLIO: 8kB Random Read for 5x30 minutes |
|
2015-02-26 00:50:25 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 175735.18 |
|
MBs/sec: 1372.93 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 472 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 41 58 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 175381.25 |
|
MBs/sec: 1370.16 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 36 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 41 58 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 176606.48 |
|
MBs/sec: 1379.73 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 34 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 42 57 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 176110.53 |
|
MBs/sec: 1375.86 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 39 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 41 57 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 177465.69 |
|
MBs/sec: 1386.45 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 37 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 42 56 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
|
|
SQLIO: 64kB Random Write for 5x30 minutes |
|
2015-02-26 03:21:25 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3415.36 |
|
MBs/sec: 213.46 |
|
latency metrics: |
|
Min_Latency(ms): 2 |
|
Avg_Latency(ms): 55 |
|
Max_Latency(ms): 257 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 81 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3390.03 |
|
MBs/sec: 211.87 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 56 |
|
Max_Latency(ms): 272 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 0 0 0 1 1 1 2 2 2 1 1 1 1 1 1 1 1 1 81 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3525.99 |
|
MBs/sec: 220.37 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 53 |
|
Max_Latency(ms): 286 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 0 0 1 1 1 2 2 2 2 2 1 1 1 1 1 1 1 1 79 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3565.23 |
|
MBs/sec: 222.82 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 53 |
|
Max_Latency(ms): 256 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 0 0 1 1 2 2 2 2 2 2 1 1 1 1 1 1 1 1 78 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3668.66 |
|
MBs/sec: 229.29 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 51 |
|
Max_Latency(ms): 238 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 0 0 1 1 1 2 2 2 2 2 1 1 1 1 1 1 1 1 79 |
|
|
|
SQLIO: 64kB Random Read for 5x30 minutes |
|
2015-02-26 05:52:38 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32346.27 |
|
MBs/sec: 2021.64 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 933 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 6 14 20 19 15 10 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32342.20 |
|
MBs/sec: 2021.38 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 3317 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 6 15 20 19 14 10 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32366.27 |
|
MBs/sec: 2022.89 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 2414 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 5 14 20 19 15 10 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32292.81 |
|
MBs/sec: 2018.30 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 966 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 5 14 20 20 15 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825219 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32360.49 |
|
MBs/sec: 2022.53 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 929 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 5 14 20 19 15 10 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
Client 3 |
|
SQLIO: 8kB Random Write for 5x30 minutes |
|
2015-02-25 19:19:05 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 25379.17 |
|
MBs/sec: 198.27 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 89 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 1 13 28 22 15 9 5 3 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 26016.88 |
|
MBs/sec: 203.25 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 86 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 12 31 24 15 8 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 26438.52 |
|
MBs/sec: 206.55 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 132 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 13 31 24 15 8 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 26183.62 |
|
MBs/sec: 204.55 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 96 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 12 31 24 15 8 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 25792.80 |
|
MBs/sec: 201.50 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 134 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 12 30 23 15 8 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
|
|
SQLIO: 8kB Random Read for 5x30 minutes |
|
2015-02-25 21:50:05 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 198043.51 |
|
MBs/sec: 1547.21 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 103 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 57 43 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 197110.61 |
|
MBs/sec: 1539.92 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 34 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 57 43 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 196650.47 |
|
MBs/sec: 1536.33 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 36 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 56 44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 197413.08 |
|
MBs/sec: 1542.28 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 37 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 57 43 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 197069.24 |
|
MBs/sec: 1539.60 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 38 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 56 44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
|
|
SQLIO: 64kB Random Write for 5x30 minutes |
|
2015-02-26 00:21:05 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 4331.58 |
|
MBs/sec: 270.72 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 43 |
|
Max_Latency(ms): 298 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 1 2 3 3 4 3 3 3 3 3 3 2 2 2 2 2 2 55 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 4289.43 |
|
MBs/sec: 268.08 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 44 |
|
Max_Latency(ms): 395 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 2 3 4 4 4 4 3 3 3 3 2 2 2 2 2 1 1 54 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 4428.12 |
|
MBs/sec: 276.75 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 42 |
|
Max_Latency(ms): 313 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 2 3 4 4 4 4 3 3 3 3 2 2 2 2 2 1 1 53 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 4465.96 |
|
MBs/sec: 279.12 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 42 |
|
Max_Latency(ms): 313 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 2 4 4 4 4 4 4 3 3 3 2 2 2 2 2 1 1 52 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 4506.50 |
|
MBs/sec: 281.65 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 42 |
|
Max_Latency(ms): 314 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 3 4 4 4 4 4 3 3 3 2 2 2 2 2 1 1 1 53 |
|
|
|
SQLIO: 64kB Random Read for 5x30 minutes |
|
2015-02-26 02:52:05 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 35137.58 |
|
MBs/sec: 2196.09 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 666 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 2 10 20 22 17 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 35079.01 |
|
MBs/sec: 2192.43 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 330 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 9 20 23 18 12 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 35086.11 |
|
MBs/sec: 2192.88 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 300 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 9 20 23 18 12 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 35120.39 |
|
MBs/sec: 2195.02 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 194 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 8 20 23 18 12 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2825227 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 35084.31 |
|
MBs/sec: 2192.76 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 321 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 9 20 23 18 12 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 |
|
Client 4 |
|
SQLIO: 8kB Random Write for 5x30 minutes |
|
2015-02-25 22:19:19 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 22997.15 |
|
MBs/sec: 179.66 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 96 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 11 25 21 15 10 6 4 2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 23909.97 |
|
MBs/sec: 186.79 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 170 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 11 28 22 15 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 24183.98 |
|
MBs/sec: 188.93 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 132 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 11 28 22 15 9 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 23895.97 |
|
MBs/sec: 186.68 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 115 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 11 27 22 15 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 23662.39 |
|
MBs/sec: 184.86 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 3 |
|
Max_Latency(ms): 98 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 1 11 27 21 15 9 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
|
|
SQLIO: 8kB Random Read for 5x30 minutes |
|
2015-02-26 00:50:19 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 180784.79 |
|
MBs/sec: 1412.38 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 217 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 46 53 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 180149.80 |
|
MBs/sec: 1407.42 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 37 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 46 53 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 182190.99 |
|
MBs/sec: 1423.36 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 33 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 47 52 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 179529.52 |
|
MBs/sec: 1402.57 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 39 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 45 54 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 181859.91 |
|
MBs/sec: 1420.78 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 35 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 47 52 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
|
|
SQLIO: 64kB Random Write for 5x30 minutes |
|
2015-02-26 03:21:19 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3741.74 |
|
MBs/sec: 233.85 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 50 |
|
Max_Latency(ms): 331 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 1 2 3 3 3 3 2 2 2 2 2 2 1 1 1 1 1 67 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3819.44 |
|
MBs/sec: 238.71 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 49 |
|
Max_Latency(ms): 322 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 2 3 4 3 3 3 2 2 2 2 1 1 1 1 1 1 1 65 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3888.50 |
|
MBs/sec: 243.03 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 48 |
|
Max_Latency(ms): 309 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 2 3 3 3 3 3 2 2 2 2 1 1 1 1 1 1 1 65 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3946.26 |
|
MBs/sec: 246.64 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 48 |
|
Max_Latency(ms): 308 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 2 3 4 3 3 3 2 2 2 2 1 1 1 1 1 1 1 64 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 4007.69 |
|
MBs/sec: 250.48 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 47 |
|
Max_Latency(ms): 290 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 1 3 4 4 4 3 3 2 2 2 2 1 1 1 1 1 1 1 63 |
|
|
|
SQLIO: 64kB Random Read for 5x30 minutes |
|
2015-02-26 05:52:19 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32834.55 |
|
MBs/sec: 2052.15 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 649 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 8 15 19 17 13 10 7 5 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32818.74 |
|
MBs/sec: 2051.17 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 182 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 7 15 19 17 13 10 7 4 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32786.73 |
|
MBs/sec: 2049.17 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 361 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 7 15 19 18 14 10 7 4 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32681.45 |
|
MBs/sec: 2042.59 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 226 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 6 14 19 18 14 10 7 4 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 2143276 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 32798.61 |
|
MBs/sec: 2049.91 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 5 |
|
Max_Latency(ms): 370 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 7 15 19 17 14 10 7 4 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
Client 5 |
|
SQLIO: 8kB Random Write for 5x30 minutes |
|
2015-02-26 03:21:41 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 19136.99 |
|
MBs/sec: 149.50 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 111 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 1 6 15 18 18 15 10 7 4 2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 19519.29 |
|
MBs/sec: 152.49 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 173 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 6 15 19 19 15 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 19798.64 |
|
MBs/sec: 154.67 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 108 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 6 15 19 19 15 11 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 19759.83 |
|
MBs/sec: 154.37 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 114 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 6 15 19 19 15 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 4 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 19600.97 |
|
MBs/sec: 153.13 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 4 |
|
Max_Latency(ms): 133 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 1 6 15 19 18 15 10 6 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
|
|
SQLIO: 8kB Random Read for 5x30 minutes |
|
2015-02-26 05:52:41 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 191097.92 |
|
MBs/sec: 1492.95 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 406 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 62 35 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 190530.03 |
|
MBs/sec: 1488.51 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 36 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 62 35 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 190156.02 |
|
MBs/sec: 1485.59 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 35 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 62 35 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 190369.22 |
|
MBs/sec: 1487.25 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 36 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 62 36 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 8KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 190113.92 |
|
MBs/sec: 1485.26 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 0 |
|
Max_Latency(ms): 38 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 62 35 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
|
|
|
SQLIO: 64kB Random Write for 5x30 minutes |
|
2015-02-26 08:23:41 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3435.08 |
|
MBs/sec: 214.69 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 55 |
|
Max_Latency(ms): 272 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 81 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3398.09 |
|
MBs/sec: 212.38 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 55 |
|
Max_Latency(ms): 4519 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 0 0 1 1 1 1 2 2 2 1 1 1 1 1 1 1 1 1 81 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3533.28 |
|
MBs/sec: 220.83 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 53 |
|
Max_Latency(ms): 268 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 0 0 1 1 1 2 2 2 2 2 1 1 1 1 1 1 1 1 79 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3571.18 |
|
MBs/sec: 223.19 |
|
latency metrics: |
|
Min_Latency(ms): 1 |
|
Avg_Latency(ms): 53 |
|
Max_Latency(ms): 5734 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 0 0 1 1 2 2 2 2 2 2 1 1 1 1 1 1 1 1 78 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads writing for 1800 secs to files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 3645.45 |
|
MBs/sec: 227.84 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 52 |
|
Max_Latency(ms): 255 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 0 0 0 0 0 0 1 1 1 2 2 2 2 1 1 1 1 1 1 1 1 1 79 |
|
|
|
SQLIO: 64kB Random Read for 5x30 minutes |
|
2015-02-26 10:54:41 |
|
|
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 29402.77 |
|
MBs/sec: 1837.67 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 6 |
|
Max_Latency(ms): 253 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 4 10 15 17 16 14 10 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 29032.54 |
|
MBs/sec: 1814.53 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 6 |
|
Max_Latency(ms): 156 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 4 10 15 16 15 14 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 28992.34 |
|
MBs/sec: 1812.02 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 6 |
|
Max_Latency(ms): 167 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 4 9 14 16 16 14 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 29258.41 |
|
MBs/sec: 1828.65 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 6 |
|
Max_Latency(ms): 276 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 0 3 9 15 17 16 14 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 |
|
sqlio v1.5.SG |
|
using system counter for latency timings, 3214909 counts per second |
|
parameter file used: C:\SQLIO_5SMB\mach5_DE.txt |
|
|
file D:\iobw.tst with 12 threads (0-11) using mask 0x0 (0) |
|
file E:\iobw.tst with 12 threads (12-23) using mask 0x0 (0) |
24 threads reading for 1800 secs from files D:\iobw.tst and E:\iobw.tst |
|
|
using 64KB random IOs |
|
enabling multiple I/Os per thread with 8 outstanding |
|
buffering set to not use file nor disk caches (as is SQL Server) |
using specified size: 819200 MB for file: D:\iobw.tst |
|
using specified size: 819200 MB for file: E:\iobw.tst |
|
initialization done |
|
CUMULATIVE DATA: |
|
throughput metrics: |
|
IOs/sec: 29017.76 |
|
MBs/sec: 1813.61 |
|
latency metrics: |
|
Min_Latency(ms): 0 |
|
Avg_Latency(ms): 6 |
|
Max_Latency(ms): 416 |
|
histogram: |
|
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ |
|
%: 0 1 4 9 14 16 16 14 11 7 4 2 1 1 0 0 0 0 0 0 0 0 0 0 0 |
|