May 14, 2015 at 1:24 pm
Guys,
We have recently implemented a SQL 2014 Always On solution running in VMware vSphere 5.5 (provided by the Ops Team!). We've ran SQLIO to gauge performance, however, we've not got anything to compare against, whats your thoughts on the results?
Database Drive, 64KB Random IO
Reads
C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -frandom -o8 -b64 -LS -Fparam_g.txt
sqlio v1.5.SG
using system counter for latency timings, 3222655 counts per second
parameter file used: param_g.txt
file g:\database\testfile.dat with 4 threads (0-3) using mask 0x0 (0)
4 threads reading for 360 secs from file g:\database\testfile.dat
using 64KB random IOs
enabling multiple I/Os per thread with 8 outstanding
using specified size: 10000 MB for file: g:\database\testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 35368.60
MBs/sec: 2210.53
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 6
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+
%: 73 27 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Writes
C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -frandom -o8 -b64 -LS -Fparam_g.txt
sqlio v1.5.SG
using system counter for latency timings, 3222655 counts per second
parameter file used: param_g.txt
file g:\database\testfile.dat with 4 threads (0-3) using mask 0x0 (0)
4 threads writing for 360 secs to file g:\database\testfile.dat
using 64KB random IOs
enabling multiple I/Os per thread with 8 outstanding
using specified size: 10000 MB for file: g:\database\testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 22411.05
MBs/sec: 1400.69
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
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+
%: 56 37 3 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
Cheers
May 14, 2015 at 1:54 pm
Looks like a healthy piece of kit you got there, first question is how these numbers compare to what it says on the box, for a mid range SAN this is fine but for a SSD kit this would be sluggish.
😎
May 14, 2015 at 2:44 pm
Thanks, this is running on a mid-range system, with 32 x 10K discs and some SSD for Tiering, i dont think the Tiering had chance to run in the tests, we've got our log drives on the SSD so it will be interesting to see those stats, although, i'm not sure if we are hitting the upper limits of the port connectivity 8GBps Fibre?
May 15, 2015 at 9:06 am
stuartw.evansuk (5/14/2015)
Guys,We have recently implemented a SQL 2014 Always On solution running in VMware vSphere 5.5 (provided by the Ops Team!). We've ran SQLIO to gauge performance,
You're running this within the virtual machine guest OS?
whats your thoughts on the results?
There's not enough results there to draw any firm conclusion.
The SQLIO run should test a wide variation of thread counts, IO request sizes and sequential\random IOs.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2015 at 11:08 am
You definitely need more counters. I would run 8k, 16k, 32k, 64k, 128k sequential and random reads/writes to evaluate the performance. From my initial view, it looks great but running all of those will give you better indicators. As you decrease the size of the transactions you should see much higher IO.
May 18, 2015 at 11:21 am
Just piling on a bit, did you have a look at SQL Server Best Practices Article
and of course Microsoft® SQL Server on VMware®
Best Practices Guide?
😎
May 18, 2015 at 11:51 am
stuartw.evansuk (5/14/2015)
file g:\database\testfile.dat with 4 threads (0-3) using mask 0x0 (0)
Also, if G:\data is actually a VMware virtual disk then I\O could well be a bottleneck anyway especially for random operations.
See the bottom of my article at this link[/url] for more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply