MS SQLIO Tests of ION SR-71mach4 | ||||||||
Server is ION SR-71mach4 with (3) 4TB RAID 5 shares, (3) X520-DA2 dual 10GbE NICs | ||||||||
3 Clients, each with dual E5 2690 Xeon processors and X520-DA2 dual 10GBE NICs. | ||||||||
Each client used one shared 4TB file. | ||||||||
Tests were started simultaneously. 1min rest between each set of 5. | ||||||||
Detailed output from tests on each client are on the other 3 tabs in this sheet. | ||||||||
SQLIO: 8kB Random Write for 5x30 minutes | ||||||||
Client 1 | Client 2 | Client 3 | Total | Average | ||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Latency |
1 | 30,513 | 3 | 30,547 | 3 | 30,550 | 3 | ||
2 | 30,502 | 3 | 30,524 | 3 | 30,527 | 3 | ||
3 | 30,511 | 3 | 30,536 | 3 | 30,531 | 3 | ||
4 | 30,518 | 3 | 30,550 | 3 | 30,552 | 3 | ||
5 | 30,508 | 3 | 30,529 | 3 | 30,525 | 3 | ||
Trimmed Mean | 30,511 | 3 | 30,537 | 3 | 30,537 | 3 | 91,585 | 3 |
716 | Mbps | |||||||
SQLIO: 8kB Random Read for 5x30 minutes | ||||||||
Client 1 | Client 2 | Client 3 | Total | Average | ||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Latency |
1 | 222,371 | 0 | 224,416 | 0 | 226,977 | 0 | ||
2 | 221,758 | 0 | 223,582 | 0 | 226,846 | 0 | ||
3 | 221,895 | 0 | 223,299 | 0 | 226,927 | 0 | ||
4 | 221,879 | 0 | 224,014 | 0 | 226,736 | 0 | ||
5 | 222,157 | 0 | 223,522 | 0 | 227,189 | 0 | ||
Trimmed Mean | 222,012 | 0 | 223,767 | 0 | 226,935 | 0 | 672,714 | 0 |
5,256 | Mbps | |||||||
SQLIO: 8kB Sequential Write for 5x30 minutes | ||||||||
Client 1 | Client 2 | Client 3 | Total | Average | ||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Latency |
1 | 9,688 | 12 | 9,659 | 12 | 10,257 | 11 | ||
2 | 9,689 | 12 | 9,674 | 12 | 10,289 | 11 | ||
3 | 9,755 | 12 | 9,700 | 12 | 10,326 | 11 | ||
4 | 9,750 | 12 | 9,734 | 12 | 10,345 | 11 | ||
5 | 9,860 | 12 | 9,829 | 12 | 10,422 | 11 | ||
Trimmed Mean | 9,749 | 12 | 9,719 | 12 | 10,328 | 11 | 29,796 | 12 |
233 | Mbps | |||||||
SQLIO: 8kB Sequential Read for 5x30 minutes | ||||||||
Client 1 | Client 2 | Client 3 | Total | Average | ||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Latency |
1 | 222,904 | 0 | 224,684 | 0 | 227,210 | 0 | ||
2 | 222,757 | 0 | 224,874 | 0 | 227,304 | 0 | ||
3 | 222,589 | 0 | 224,955 | 0 | 227,155 | 0 | ||
4 | 222,928 | 0 | 224,872 | 0 | 227,363 | 0 | ||
5 | 222,901 | 0 | 225,277 | 0 | 227,289 | 0 | ||
Trimmed Mean | 222,816 | 0 | 224,932 | 0 | 227,264 | 0 | 675,013 | 0 |
5,274 | Mbps | |||||||
SQLIO: 64kB Random Write for 5x30 minutes | ||||||||
Client 1 | Client 2 | Client 3 | Total | Average | ||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Latency |
1 | 6,477 | 19 | 6,380 | 19 | 6,499 | 19 | ||
2 | 6,156 | 20 | 6,148 | 20 | 6,281 | 19 | ||
3 | 6,741 | 18 | 6,710 | 18 | 6,918 | 18 | ||
4 | 6,614 | 18 | 6,613 | 18 | 6,754 | 18 | ||
5 | 6,504 | 19 | 6,463 | 19 | 6,720 | 18 | ||
Trimmed Mean | 6,498 | 19 | 6,463 | 19 | 6,634 | 18 | 19,596 | 19 |
1,225 | Mbps | |||||||
SQLIO: 64kB Random Read for 5x30 minutes | ||||||||
Client 1 | Client 2 | Client 3 | Total | Average | ||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Latency |
1 | 37,603 | 2 | 37,510 | 2 | 37,428 | 2 | ||
2 | 37,575 | 2 | 37,491 | 2 | 37,414 | 2 | ||
3 | 37,580 | 2 | 37,485 | 2 | 37,426 | 2 | ||
4 | 37,587 | 2 | 37,501 | 2 | 37,433 | 2 | ||
5 | 37,593 | 2 | 37,484 | 2 | 37,419 | 2 | ||
Trimmed Mean | 37,588 | 2 | 37,494 | 2 | 37,424 | 2 | 112,506 | 2 |
7,032 | Mbps | |||||||
SQLIO: 64kB Sequential Write for 5x30 minutes | ||||||||
Client 1 | Client 2 | Client 3 | Total | Average | ||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Latency |
1 | 7,173 | 17 | 7,159 | 17 | 7,233 | 17 | ||
2 | 8,417 | 14 | 8,378 | 14 | 8,347 | 14 | ||
3 | 8,828 | 13 | 8,853 | 13 | 8,788 | 14 | ||
4 | 8,782 | 14 | 8,774 | 14 | 8,878 | 13 | ||
5 | 9,421 | 13 | 9,381 | 13 | 9,133 | 13 | ||
Trimmed Mean | 8,524 | 14 | 8,509 | 14 | 8,476 | 14 | 25,509 | 14 |
1,594 | Mbps | |||||||
SQLIO: 64kB Sequential Read for 5x30 minutes | ||||||||
Client 1 | Client 2 | Client 3 | Total | Average | ||||
Run # | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Ave. Lat. | IOPS | Latency |
1 | 37,635 | 2 | 37,521 | 2 | 37,407 | 2 | ||
2 | 37,638 | 2 | 37,517 | 2 | 37,438 | 2 | ||
3 | 37,655 | 2 | 37,532 | 2 | 37,409 | 2 | ||
4 | 37,642 | 2 | 37,526 | 2 | 37,417 | 2 | ||
5 | 37,645 | 2 | 37,528 | 2 | 37,420 | 2 | ||
Trimmed Mean | 37,643 | 2 | 37,525 | 2 | 37,418 | 2 | 112,586 | 2 |
7,037 | Mbps |
SQLIO: 8kB Random Write for 5x30 minutes | |
2013-11-06 13:53:41 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30512.77 | |
MBs/sec: 238.38 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 158 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 48 29 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30502.42 | |
MBs/sec: 238.30 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 74 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 48 29 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30510.97 | |
MBs/sec: 238.36 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 78 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 48 29 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30518.28 | |
MBs/sec: 238.42 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 59 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 48 29 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30508.09 | |
MBs/sec: 238.34 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 77 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 48 29 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 8kB Random Read for 5x30 minutes | |
2013-11-06 16:24:42 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 222371.24 | |
MBs/sec: 1737.27 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 8 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 221757.84 | |
MBs/sec: 1732.48 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 35 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 221894.77 | |
MBs/sec: 1733.55 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 17 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 221879.05 | |
MBs/sec: 1733.43 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 18 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 222157.48 | |
MBs/sec: 1735.60 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 16 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 8kB Sequential Write for 5x30 minutes | |
2013-11-06 18:55:42 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9688.15 | |
MBs/sec: 75.68 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 220 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9689.19 | |
MBs/sec: 75.69 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 218 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 9 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9755.23 | |
MBs/sec: 76.21 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 219 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 9 4 5 4 5 5 5 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9750.11 | |
MBs/sec: 76.17 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 237 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9860.16 | |
MBs/sec: 77.03 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 219 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 4 5 4 5 5 5 4 4 4 4 3 3 3 3 3 3 3 2 2 2 2 2 2 15 | |
SQLIO: 8kB Sequential Read for 5x30 minutes | |
2013-11-06 21:26:42 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 222904.36 | |
MBs/sec: 1741.44 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 20 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 222756.76 | |
MBs/sec: 1740.28 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 16 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 222589.17 | |
MBs/sec: 1738.97 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 17 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 222928.32 | |
MBs/sec: 1741.62 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 19 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 222900.92 | |
MBs/sec: 1741.41 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 18 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 64kB Random Write for 5x30 minutes | |
2013-11-06 23:57:42 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6476.90 | |
MBs/sec: 404.80 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 19 | |
Max_Latency(ms): 185 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 1 2 3 4 4 4 4 4 4 4 4 4 4 3 3 3 3 2 2 2 2 2 29 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6155.68 | |
MBs/sec: 384.73 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 20 | |
Max_Latency(ms): 227 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 2 3 5 5 5 5 4 4 4 4 3 3 3 3 3 2 2 2 2 2 2 2 31 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6741.18 | |
MBs/sec: 421.32 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 18 | |
Max_Latency(ms): 163 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 3 5 6 6 6 5 5 4 4 4 3 3 3 2 2 2 2 2 1 1 1 1 27 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6614.04 | |
MBs/sec: 413.37 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 18 | |
Max_Latency(ms): 188 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 3 5 6 6 6 5 5 4 4 4 3 3 3 2 2 2 2 2 2 1 1 1 28 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6503.79 | |
MBs/sec: 406.48 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 19 | |
Max_Latency(ms): 188 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 3 5 6 6 6 5 5 4 4 3 3 3 3 2 2 2 2 2 2 2 1 1 28 | |
SQLIO: 64kB Random Read for 5x30 minutes | |
2013-11-07 02:28:42 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37603.15 | |
MBs/sec: 2350.19 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 5575 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 27 41 20 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37575.06 | |
MBs/sec: 2348.44 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 5526 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 28 41 20 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37580.25 | |
MBs/sec: 2348.76 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3327 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 28 41 20 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37587.00 | |
MBs/sec: 2349.18 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 4493 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 28 41 20 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37593.49 | |
MBs/sec: 2349.59 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 6631 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 28 41 20 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
SQLIO: 64kB Sequential Write for 5x30 minutes | |
2013-11-07 04:59:43 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 7173.22 | |
MBs/sec: 448.32 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 17 | |
Max_Latency(ms): 177 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 2 5 6 5 4 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 2 29 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 8417.11 | |
MBs/sec: 526.06 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 14 | |
Max_Latency(ms): 226 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 3 5 5 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 20 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 8828.21 | |
MBs/sec: 551.76 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 13 | |
Max_Latency(ms): 208 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 4 5 6 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 17 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 8781.76 | |
MBs/sec: 548.86 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 14 | |
Max_Latency(ms): 179 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 4 5 6 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 18 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9420.94 | |
MBs/sec: 588.80 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 13 | |
Max_Latency(ms): 209 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 6 6 5 5 4 4 4 4 4 4 4 4 4 4 3 3 3 3 3 3 2 2 2 14 | |
SQLIO: 64kB Sequential Read for 5x30 minutes | |
2013-11-07 07:30:43 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37635.20 | |
MBs/sec: 2352.20 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3023 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 30 42 17 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37638.19 | |
MBs/sec: 2352.38 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3290 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 30 42 17 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37654.72 | |
MBs/sec: 2353.42 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 4510 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 29 43 17 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37641.74 | |
MBs/sec: 2352.60 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 6641 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 30 43 17 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37645.22 | |
MBs/sec: 2352.82 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3937 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 29 43 17 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
SQLIO: done | |
2013-11-07 10:00:43 |
SQLIO: 8kB Random Write for 5x30 minutes | |
2013-11-06 13:53:43 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30547.46 | |
MBs/sec: 238.65 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 64 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 48 29 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30524.31 | |
MBs/sec: 238.47 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 66 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 48 28 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30536.35 | |
MBs/sec: 238.56 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 62 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 48 28 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30550.24 | |
MBs/sec: 238.67 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 54 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 48 29 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30528.73 | |
MBs/sec: 238.50 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 53 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 48 28 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 8kB Random Read for 5x30 minutes | |
2013-11-06 16:24:43 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 224416.38 | |
MBs/sec: 1753.25 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 8 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 99 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 223582.23 | |
MBs/sec: 1746.73 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 142 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 223299.49 | |
MBs/sec: 1744.52 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 16 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 224013.54 | |
MBs/sec: 1750.10 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 14 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 99 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 223522.21 | |
MBs/sec: 1746.26 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 16 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 8kB Sequential Write for 5x30 minutes | |
2013-11-06 18:55:43 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9658.75 | |
MBs/sec: 75.45 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 236 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 16 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9674.31 | |
MBs/sec: 75.58 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 225 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 9 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9700.36 | |
MBs/sec: 75.78 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 231 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9733.60 | |
MBs/sec: 76.04 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 242 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 4 5 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9829.41 | |
MBs/sec: 76.79 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 231 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 4 5 4 5 5 5 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 15 | |
SQLIO: 8kB Sequential Read for 5x30 minutes | |
2013-11-06 21:26:43 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 224683.99 | |
MBs/sec: 1755.34 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 18 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 224873.94 | |
MBs/sec: 1756.82 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 17 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 224955.10 | |
MBs/sec: 1757.46 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 13 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 224871.81 | |
MBs/sec: 1756.81 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 19 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 225276.63 | |
MBs/sec: 1759.97 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 13 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 64kB Random Write for 5x30 minutes | |
2013-11-06 23:57:43 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6380.03 | |
MBs/sec: 398.75 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 19 | |
Max_Latency(ms): 191 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 1 3 4 4 5 5 4 4 4 4 4 4 3 3 3 3 2 2 2 2 2 2 29 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6147.81 | |
MBs/sec: 384.23 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 20 | |
Max_Latency(ms): 226 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 2 3 5 5 5 5 4 4 4 4 3 3 3 3 3 2 2 2 2 2 2 2 31 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6710.36 | |
MBs/sec: 419.39 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 18 | |
Max_Latency(ms): 160 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 3 5 6 6 6 5 5 4 4 4 3 3 3 2 2 2 2 2 1 1 1 1 28 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6613.44 | |
MBs/sec: 413.34 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 18 | |
Max_Latency(ms): 179 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 3 5 6 6 6 5 5 4 4 3 3 3 3 2 2 2 2 2 2 2 1 1 29 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6463.22 | |
MBs/sec: 403.95 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 19 | |
Max_Latency(ms): 189 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 3 5 6 6 6 5 5 4 4 3 3 3 3 2 2 2 2 2 2 1 1 1 29 | |
SQLIO: 64kB Random Read for 5x30 minutes | |
2013-11-07 02:28:43 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37510.04 | |
MBs/sec: 2344.37 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3067 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 26 41 22 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37491.27 | |
MBs/sec: 2343.20 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 2458 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 26 41 22 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37484.55 | |
MBs/sec: 2342.78 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 4525 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 27 41 21 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37500.71 | |
MBs/sec: 2343.79 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 4527 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 26 41 22 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37483.53 | |
MBs/sec: 2342.72 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3043 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 27 41 21 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
SQLIO: 64kB Sequential Write for 5x30 minutes | |
2013-11-07 04:59:43 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 7158.92 | |
MBs/sec: 447.43 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 17 | |
Max_Latency(ms): 182 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 2 5 6 5 4 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 2 29 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 8377.89 | |
MBs/sec: 523.61 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 14 | |
Max_Latency(ms): 183 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 3 5 5 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 20 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 8853.25 | |
MBs/sec: 553.32 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 13 | |
Max_Latency(ms): 214 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 4 5 6 5 4 4 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 2 2 17 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 8773.92 | |
MBs/sec: 548.37 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 14 | |
Max_Latency(ms): 193 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 4 5 6 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 18 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9380.96 | |
MBs/sec: 586.31 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 13 | |
Max_Latency(ms): 179 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 5 6 5 5 4 4 4 4 4 4 4 4 4 4 3 3 3 3 3 3 2 2 2 15 | |
SQLIO: 64kB Sequential Read for 5x30 minutes | |
2013-11-07 07:30:43 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37520.82 | |
MBs/sec: 2345.05 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3021 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 29 40 20 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37516.85 | |
MBs/sec: 2344.80 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3952 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 29 40 20 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37531.81 | |
MBs/sec: 2345.73 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3042 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 28 40 20 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37525.82 | |
MBs/sec: 2345.36 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3010 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 29 40 20 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825227 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37528.49 | |
MBs/sec: 2345.53 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 4600 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 28 40 20 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
SQLIO: done | |
2013-11-07 10:00:44 |
SQLIO: 8kB Random Write for 5x30 minutes | |
2013-11-06 13:53:41 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30549.96 | |
MBs/sec: 238.67 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 68 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 47 30 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30526.56 | |
MBs/sec: 238.48 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 75 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 47 29 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30531.46 | |
MBs/sec: 238.52 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 82 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 47 29 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30551.86 | |
MBs/sec: 238.68 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 76 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 47 30 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 30525.38 | |
MBs/sec: 238.47 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 3 | |
Max_Latency(ms): 79 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 5 47 29 12 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 8kB Random Read for 5x30 minutes | |
2013-11-06 16:24:41 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 226977.14 | |
MBs/sec: 1773.25 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 9 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 226846.22 | |
MBs/sec: 1772.23 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 17 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 226926.87 | |
MBs/sec: 1772.86 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 18 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 226735.98 | |
MBs/sec: 1771.37 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 19 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 227188.98 | |
MBs/sec: 1774.91 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 18 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 98 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 8kB Sequential Write for 5x30 minutes | |
2013-11-06 18:55:41 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 10256.92 | |
MBs/sec: 80.13 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 11 | |
Max_Latency(ms): 115 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 4 6 4 5 5 4 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 14 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 10289.00 | |
MBs/sec: 80.38 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 11 | |
Max_Latency(ms): 161 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 4 6 4 5 5 5 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 14 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 10325.92 | |
MBs/sec: 80.67 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 11 | |
Max_Latency(ms): 161 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 4 6 4 5 5 5 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 14 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 10345.04 | |
MBs/sec: 80.82 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 11 | |
Max_Latency(ms): 147 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 4 6 4 5 5 5 4 4 4 3 3 3 3 3 3 3 3 2 2 2 2 2 2 14 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 10421.78 | |
MBs/sec: 81.42 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 11 | |
Max_Latency(ms): 143 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 10 4 6 4 5 5 5 4 4 4 4 3 3 3 3 3 3 3 2 2 2 2 2 2 14 | |
SQLIO: 8kB Sequential Read for 5x30 minutes | |
2013-11-06 21:26:41 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 227210.47 | |
MBs/sec: 1775.08 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 17 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 97 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 227304.30 | |
MBs/sec: 1775.81 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 15 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 97 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 227155.01 | |
MBs/sec: 1774.64 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 15 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 97 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 227363.36 | |
MBs/sec: 1776.27 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 15 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 97 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 227289.21 | |
MBs/sec: 1775.69 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 17 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 97 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
SQLIO: 64kB Random Write for 5x30 minutes | |
2013-11-06 23:57:41 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6499.21 | |
MBs/sec: 406.20 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 19 | |
Max_Latency(ms): 169 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 0 1 2 3 4 4 4 4 4 4 4 4 4 3 3 3 3 3 3 2 2 2 2 30 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6280.91 | |
MBs/sec: 392.55 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 19 | |
Max_Latency(ms): 186 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 2 4 5 6 5 5 4 4 4 4 3 3 3 3 2 2 2 2 2 2 2 2 29 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6917.85 | |
MBs/sec: 432.36 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 18 | |
Max_Latency(ms): 176 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 3 5 6 6 6 5 5 4 4 4 3 3 3 2 2 2 2 2 2 2 1 1 27 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6754.04 | |
MBs/sec: 422.12 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 18 | |
Max_Latency(ms): 209 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 3 5 6 6 5 5 5 4 4 3 3 3 3 2 2 2 2 2 2 2 2 1 28 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6719.59 | |
MBs/sec: 419.97 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 18 | |
Max_Latency(ms): 170 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 3 5 6 6 6 5 5 4 4 3 3 3 3 2 2 2 2 2 2 2 2 1 27 | |
SQLIO: 64kB Random Read for 5x30 minutes | |
2013-11-07 02:28:41 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37428.47 | |
MBs/sec: 2339.27 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 2786 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 1 24 42 23 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37414.23 | |
MBs/sec: 2338.38 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3614 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 1 24 42 22 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37426.45 | |
MBs/sec: 2339.15 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3648 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 1 24 42 22 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37433.32 | |
MBs/sec: 2339.58 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 4612 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 1 24 42 23 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37418.90 | |
MBs/sec: 2338.68 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 4829 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 1 24 42 22 7 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
SQLIO: 64kB Sequential Write for 5x30 minutes | |
2013-11-07 04:59:42 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 7232.86 | |
MBs/sec: 452.05 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 17 | |
Max_Latency(ms): 177 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 1 3 5 6 5 4 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 2 28 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 8347.27 | |
MBs/sec: 521.70 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 14 | |
Max_Latency(ms): 188 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 3 5 5 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 20 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 8787.79 | |
MBs/sec: 549.23 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 14 | |
Max_Latency(ms): 198 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 4 5 6 5 5 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 18 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 8878.00 | |
MBs/sec: 554.87 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 13 | |
Max_Latency(ms): 194 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 4 5 6 5 4 4 4 4 3 3 3 3 3 3 3 3 3 3 3 3 3 2 2 17 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads writing for 1800 secs to file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 9133.49 | |
MBs/sec: 570.84 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 13 | |
Max_Latency(ms): 204 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 5 6 5 5 4 4 4 4 4 4 4 4 4 4 3 3 3 3 3 3 2 2 2 16 | |
SQLIO: 64kB Sequential Read for 5x30 minutes | |
2013-11-07 07:30:42 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37406.66 | |
MBs/sec: 2337.91 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 9628 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 24 45 21 6 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37437.73 | |
MBs/sec: 2339.85 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 5475 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 22 46 22 6 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37408.79 | |
MBs/sec: 2338.04 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 4315 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 23 45 21 6 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37417.32 | |
MBs/sec: 2338.58 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 4868 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 23 45 21 6 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2825229 counts per second | |
parameter file used: C:\Users\Administrator\Documents\SQLIO\mach4_64threadM.txt | |
file M:\iobw.tst with 64 threads (0-63) using mask 0x0 (0) | |
64 threads reading for 1800 secs from file M:\iobw.tst | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 2 outstanding | |
buffering set to not use file nor disk caches (as is SQL Server) | |
using specified size: 4194304 MB for file: M:\iobw.tst | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 37419.60 | |
MBs/sec: 2338.72 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 3037 | |
histogram: | |
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ | |
%: 0 23 46 22 6 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
SQLIO: done | |
2013-11-07 10:00:43 |