Unsolved
This post is more than 5 years old
7 Posts
0
5120
January 19th, 2015 08:00
Feedback about Dell Compellent performance.
I do like to do annual review of our Dell Compellent/SAN. I did perform a quick (not comprehensive ) test few days ago and got the following results:
C:\Program Files (x86)\SQLIO>sqlio -kW -t1 -s60 -o8 -frandom -b64 -BH -LS xxxxxxxxx
sqlio v1.5.SG
using system counter for latency timings, 3579545 counts per second
1 thread writing for 60 secs to file E:\SQL_Data2\MSSQL\testfile.dat
using 64KB 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: 10480 MB for file: E:\SQL_Data2\MSSQL\testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 5353.23
MBs/sec: 334.57
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 1
Max_Latency(ms): 292
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+
%: 26 71 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
C:\Program Files (x86)\SQLIO>sqlio -kW -t2 -s60 -o8 -frandom -b64 -BH -LS xxxxxxxxx
sqlio v1.5.SG
using system counter for latency timings, 3579545 counts per second
2 threads writing for 60 secs to file E:\SQL_Data2\MSSQL\testfile.dat
using 64KB 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: 10480 MB for file: E:\SQL_Data2\MSSQL\testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 5124.29
MBs/sec: 320.26
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 535
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+
%: 12 78 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3
C:\Program Files (x86)\SQLIO>sqlio -kW -t4 -s60 -o8 -frandom -b64 -BH -LS xxxxxxxxx
sqlio v1.5.SG
using system counter for latency timings, 3579545 counts per second
4 threads writing for 60 secs to file E:\SQL_Data2\MSSQL\testfile.dat
using 64KB 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: 10480 MB for file: E:\SQL_Data2\MSSQL\testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 5324.86
MBs/sec: 332.80
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 685
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+
%: 4 71 13 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7
I do not have the complete specs of the hardware (yet) but I would like to know opinion about how it is running now.
A quick glance tells me that the latency values look good to me. I have doubts about the throughput in MBs/sec.
This quick test was performed via SQLIO against one particular LUN that is holding data files for a SQL server. The SQL server runs on VMware by the way, using vmdk file format.
Any comments of feedback is welcome.