Storage Boards Cleanup
To make it easier to find information about HPE Storage products and solutions, we are doing spring cleaning. This includes consolidation of some older boards, and a simpler structure that more accurately reflects how people use HPE Storage.
HPE StoreVirtual Storage / LeftHand
cancel
Showing results for 
Search instead for 
Did you mean: 

HP Lefthand SAN and use for SQL 2012 cluster

largechicken
Occasional Contributor

HP Lefthand SAN and use for SQL 2012 cluster

Hello all,

 

Just if someone can advice me regarding my SQLIO results i have run from one of my WMware virtual test SQL servers to my ISCSI 64K formatted drive on the same network 10 raided Lefthand SAN. Are these results consisted with my 1GB ISCSI SAN and is it enough to support a busy SQL cluster? Thanks

 

C:\Program Files (x86)\SQLIO>sqlio -kW -t8 -s1200 -o8 -frandom -b8 -BH -LS I:\Te
stFile.dat
sqlio v1.5.SG
using system counter for latency timings, 14318180 counts per second
8 threads writing for 1200 secs to file I:\TestFile.dat
        using 8KB random IOs
        enabling multiple I/Os per thread with 8 outstanding
        buffering set to use hardware disk cache (but not file cache)
using current size: 24576 MB for file: I:\TestFile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec:  2208.76
MBs/sec:    17.25
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 28
Max_Latency(ms): 820
histogram:
ms: 0  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 61  7  1  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0 30

C:\Program Files (x86)\SQLIO>sqlio -kR -t8 -s1200 -o8 -frandom -b8 -BH -LS I:\Te
stFile.dat
sqlio v1.5.SG
using system counter for latency timings, 14318180 counts per second
8 threads reading for 1200 secs from file I:\TestFile.dat
        using 8KB random IOs
        enabling multiple I/Os per thread with 8 outstanding
        buffering set to use hardware disk cache (but not file cache)
using current size: 24576 MB for file: I:\TestFile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec:  6732.05
MBs/sec:    52.59
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 9
Max_Latency(ms): 937
histogram:
ms: 0  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  1  2  5 10 13 13 12  9  7  5  4  3  3  2  2  1  1  1  1  1  0  0  0  3

C:\Program Files (x86)\SQLIO>sqlio -kW -t8 -s1200 -o8 -fsequential -b64 -BH -LS
I:\TestFile.dat
sqlio v1.5.SG
using system counter for latency timings, 14318180 counts per second
8 threads writing for 1200 secs to file I:\TestFile.dat
        using 64KB sequential IOs
        enabling multiple I/Os per thread with 8 outstanding
        buffering set to use hardware disk cache (but not file cache)
using current size: 24576 MB for file: I:\TestFile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec:   511.87
MBs/sec:    31.99
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 124
Max_Latency(ms): 1580
histogram:
ms: 0  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  1  2  1  1  1  1  1  1  1  1  1  1  1  1  1  1  1  1  1  1  1 76

C:\Program Files (x86)\SQLIO>sqlio -kR -t8 -s1200 -o8 -fsequential -b64 -BH -LS
I:\TestFile.dat
sqlio v1.5.SG
using system counter for latency timings, 14318180 counts per second
8 threads reading for 1200 secs from file I:\TestFile.dat
        using 64KB sequential IOs
        enabling multiple I/Os per thread with 8 outstanding
        buffering set to use hardware disk cache (but not file cache)
using current size: 24576 MB for file: I:\TestFile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec:  1197.95
MBs/sec:    74.87
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 52
Max_Latency(ms): 1070
histogram:
ms: 0  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  2  2  1  1  1  1  1  1  1  1  1  1  1  1  1  1  1  1  1  1  1 70

1 REPLY
Ravi_K
HPE Pro

Re: HP Lefthand SAN and use for SQL 2012 cluster

Hi

 

there is not sufficient information provided to answer your query related to performance. However, I have attached a basic Performance guide for understanding of the environment and requirements.

 

Regards

Ravi