HP I/O Accellerator Card – Test

This week i had the honor to test a G2-Series HP I/O-Accellerator Card.
Installation and Post-Configuration of the card is very easy. So you could go ahead immediately with testing these Hot Stuff.

We configured the card to 50% Performance, so we loosed 50% of the available space on the I/O-Card. But for our reasons, to put the TEMPDB of MS SQL-Server 2008 R2 and an Archive log of an ERP-System database on it, shoud this be space enough.

So here are the test results. I don’t wan’t to comment to much. Look at the results. They are self explaining.

Random Read Test (SQLIO – 8 Threads, 16 Outstanding Requests, 64 Block read)

SQLIO -kR -t8 -s3600 -dF -o16 -frandom -b64 -BH -LS testfile_read.dat
sqlio v1.5.SG
using system counter for latency timings, 2050878 counts per second
8 threads reading for 3600 secs from file F:testfile_read.dat
        using 64KB random IOs
        enabling multiple I/Os per thread with 16 outstanding
        buffering set to use hardware disk cache (but not file cache)
using current size: 51200 MB for file: F:testfile_read.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 21116.24
MBs/sec:  1319.76
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 263
histogram:
ms: 0  1  2  3  4  5  6  7  8  9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%:  0 12 15 13 11  9  8  6  5  4  3  3  2  2  1  1  1  1  0  0  0  0  0  0  0

Testing Random IO-Reads
SQLIO -kR -t8 -s3600 -dF -o16 -frandom -b64 -BH -LS testfile_read.dat
sqlio v1.5.SG
using system counter for latency timings, 2050878 counts per second
8 threads reading for 3600 secs from file F:testfile_read.dat
        using 64KB random IOs
        enabling multiple I/Os per thread with 16 outstanding
        buffering set to use hardware disk cache (but not file cache)
using current size: 51200 MB for file: F:testfile_read.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 20267.48
MBs/sec:  1266.71
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
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+
%:  1 12 15 13 10  9  7  6  5  4  4  3  2  2  2  1  1  1  1  0  0  0  0  0  1

Testing Random IO-Reads
SQLIO -kR -t8 -s3600 -dF -o16 -frandom -b64 -BH -LS testfile_read.dat
sqlio v1.5.SG
using system counter for latency timings, 2050878 counts per second
8 threads reading for 3600 secs from file F:testfile_read.dat
        using 64KB random IOs
        enabling multiple I/Os per thread with 16 outstanding
        buffering set to use hardware disk cache (but not file cache)
using current size: 51200 MB for file: F:testfile_read.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 21082.65
MBs/sec:  1317.66
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 203
histogram:
ms: 0  1  2  3  4  5  6  7  8  9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%:  0 12 15 13 11  9  8  6  5  4  4  3  2  2  1  1  1  1  0  0  0  0  0  0  0

Sequential Write Test (SQLIO)

Creating Testfile...
sqlio v1.5.SG
using system counter for latency timings, 2050878 counts per second
parameter file used: param.txt
        file F:\testfile_read.dat with 8 threads (0-7) using mask 0x0 (0)
8 threads writing for 5 secs to file F:\testfile_read.dat
        using 64KB random IOs
        enabling multiple I/Os per thread with 1 outstanding
        buffering set to use hardware disk cache (but not file cache)
size of file F:\testfile_read.dat needs to be: 53687091200 bytes
current file size:      0 bytes
need to expand by:      53687091200 bytes
expanding F:\testfile_read.dat ... done.
using specified size: 51200 MB for file: F:\testfile_read.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 10258.38
MBs/sec:   641.14
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 7
histogram:
ms: 0  1  2  3  4  5  6  7  8  9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 87  7  4  1  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0