I wonder if someone can post Microsoft SQLIO benchmarks with an FusionIO card?
I'm interested on how it performs on 8kb and 64kb random writes
sqlio -frandom -kW -b8 -s60 -LS -BN -Fparam.txt
//Christian
Please let me know what you think.
This is the test for 640GB IODrive Duo.
sqlio v1.5.SG
using system counter for latency timings, 2597714 counts per second parameter file used: param.txt file V:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) 2 threads writing for 60 secs to file V:\testfile.dat using 8KB random IOs buffering set to not use file nor disk caches (as is SQL Server) size of file V:\testfile.dat needs to be: 104857600 bytes current file size: 0 bytes need to expand by: 104857600 bytes expanding V:\testfile.dat ... done. using specified size: 100 MB for file: V:\testfile.dat initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 10578.33 MBs/sec: 82.64 latency metrics: Min_Latency(ms): 0 Avg_Latency(ms): 0 Max_Latency(ms): 60 histogram: ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
64KB
using system counter for latency timings, 2597714 counts per second parameter file used: param.txt file V:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) 2 threads writing for 60 secs to file V:\testfile.dat using 64KB random IOs buffering set to not use file nor disk caches (as is SQL Server) using specified size: 100 MB for file: V:\testfile.dat initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 6926.83 MBs/sec: 432.92 latency metrics: Min_Latency(ms): 0 Avg_Latency(ms): 0 Max_Latency(ms): 61 histogram: ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
This is for 80GB SLC IODrive (The drive was still in use as I have installed all the programs & the temp are on this drive) .
sqlio v1.5.SG using system counter for latency timings, 2597714 counts per second parameter file used: param.txt file P:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) 2 threads writing for 60 secs to file P:\testfile.dat using 8KB random IOs buffering set to not use file nor disk caches (as is SQL Server) size of file P:\testfile.dat needs to be: 104857600 bytes current file size: 0 bytes need to expand by: 104857600 bytes expanding P:\testfile.dat ... done. using specified size: 100 MB for file: P:\testfile.dat initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 11682.28 MBs/sec: 91.26 latency metrics: Min_Latency(ms): 0 Avg_Latency(ms): 0 Max_Latency(ms): 37 histogram: ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ %: 100 0 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, 2597714 counts per second parameter file used: param.txt file P:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) 2 threads writing for 60 secs to file P:\testfile.dat using 64KB random IOs buffering set to not use file nor disk caches (as is SQL Server) using specified size: 100 MB for file: P:\testfile.dat initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 7406.97 MBs/sec: 462.93 latency metrics: Min_Latency(ms): 0 Avg_Latency(ms): 0 Max_Latency(ms): 38 histogram: ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Thanks for the benchmark figures. In my view it is the sort of figures required to motivate ioDrives in a MS SQL environment
For the sake of completeness would it be possible to run the equivalent read benchmarks (as opposed to write benchmarks) on the ioDrive Duo 640GB, please?
Regards,
Tony T
8KB
sqlio v1.5.SG using system counter for latency timings, 2597685 counts per second parameter file used: param.txt file v:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) 2 threads reading for 60 secs from file v:\testfile.dat using 8KB random IOs buffering set to not use file nor disk caches (as is SQL Server) size of file v:\testfile.dat needs to be: 104857600 bytes current file size: 0 bytes need to expand by: 104857600 bytes expanding v:\testfile.dat ... done. using specified size: 100 MB for file: v:\testfile.dat initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 10393.86 MBs/sec: 81.20 latency metrics: Min_Latency(ms): 0 Avg_Latency(ms): 0 Max_Latency(ms): 113 histogram: ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ %: 100 0 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, 2597685 counts per second parameter file used: param.txt file v:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) 2 threads reading for 60 secs from file v:\testfile.dat using 64KB random IOs buffering set to not use file nor disk caches (as is SQL Server) using specified size: 100 MB for file: v:\testfile.dat initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 6508.23 MBs/sec: 406.76 latency metrics: Min_Latency(ms): 0 Avg_Latency(ms): 0 Max_Latency(ms): 109 histogram: ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
This is for 80GB SLC IODrive(The drive was still in use as I have installed all the programs & the temp are on this drive)
sqlio v1.5.SG using system counter for latency timings, 2597685 counts per second parameter file used: param.txt file P:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) 2 threads reading for 60 secs from file P:\testfile.dat using 8KB random IOs buffering set to not use file nor disk caches (as is SQL Server) size of file P:\testfile.dat needs to be: 104857600 bytes current file size: 0 bytes need to expand by: 104857600 bytes expanding P:\testfile.dat ... done. using specified size: 100 MB for file: P:\testfile.dat initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 13326.96 MBs/sec: 104.11 latency metrics: Min_Latency(ms): 0 Avg_Latency(ms): 0 Max_Latency(ms): 29 histogram: ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
C:\SQLIO>sqlio -frandom -kR -b64 -s60 -LS -BN -Fparam.txt
sqlio v1.5.SG using system counter for latency timings, 2597685 counts per second parameter file used: param.txt file P:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) 2 threads reading for 60 secs from file P:\testfile.dat using 64KB random IOs buffering set to not use file nor disk caches (as is SQL Server) using specified size: 100 MB for file: P:\testfile.dat initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 8274.22 MBs/sec: 517.13 latency metrics: Min_Latency(ms): 0 Avg_Latency(ms): 0 Max_Latency(ms): 105 histogram: ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+ %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Hi Tony,
If you have any other questions about SQL Server environments and case studies, feel free to shoot me a note at tallen@fusionio.com.
Thanks,
Taylor
http://www.sqlservercentral.com/articles/SSD+Disks/69693/
For your viewing pleasure.
-wes