Solved

HP DL380P / P420i Best SSD Configuration

Posted on 2013-12-29
10
4,071 Views
Last Modified: 2013-12-30
Hello Folks,

I am setting up an HP DL380P / P420i server for ESXI and want to know if anyone has had any experience using 3rd party SSD's in this machine. I need 1TB of storage for 6VM's so was thinking of using 8 of either the Samsung 840 Pro SSD's or 8 of the Intel DC S3700 drives in RAID 10 to get maximum IOPs. Two of the VM's run databases so I want the best performance possible. I would go with genuine HP SSD's but it would cost me 10K just for the drives which is not in the budget. Any advice would be greatly appreciated!
0
Comment
Question by:JohnnyD74
  • 5
  • 4
10 Comments
 
LVL 118

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
ID: 39745109
We've experimented with Samsung 840 Pro SSDs (MZ-7TD250) and Intel DC S3700, consumer drives (we've also experimented with OCZ and Kingston, Corsair) in our labs with ProLiant Servers and different Smart Array controllers and we have had mixed results...when used in RAID sets, single drives appear to work fine. BUT, when RAIDed...

1. single SSDs do not respond, appear disconnected from the SATA BUS, and then requires a RAID rebuild.

2. RAID requires rebuild after server restarts.

So for production systems, we use Fusion-IO products, which are OEMed to HP.

https://www.fusionio.com/partners/HP

http://www.fusionio.com/products/iodrive-duo/

We use the Fusion-IO Duo Drives, which are PCI-Express cards for Datastores, supported by HP, and also on the VMware HCL for datastores.

FusionIO IO-DriveDuo 640GB
(~200,000 IOPS and >800MB/s throughput per card)

We then install ESXi onto USB flash drives or SD cards, to save the SSD storage for VM usage only.

Here is the VMware KB on installing 5.x on USB/SD:
http://kb.vmware.com/kb/2004784

This will give you the maximum number of IOPS available to the VM, but do you really need all this speed for your database?

How many IOPS do you need for your database?

Just be aware, sometimes the bottleneck can be the virtual environment, not the datastore, and a physical server with ZERO hypervisor can be best, and give you the best performance for an SQL database.

e.g. Best Performance = NO Hypervisor!

Do not get me wrong here, I've been doing virtualisation for a while now and I'm a big fan, and thank the industry for it, check my profile, BUT databases are tricky servers and applications to virtualise, and if you truly are seeking Best Performance possible, do not virtualise it, unless there are other reasons, to want to virtualise, e.g. DR, Backup, Restore, Support, Server Consolidation, but all these are a compromise when seeking performance.

One of the common *unanswered* (as far as the user is concerened!) questions on EE, is why is my SQL server performance poor on Hypervisor X!

and, most move it back to a phsyical server.
0
 
LVL 55

Expert Comment

by:andyalder
ID: 39745210
HP are a bit behind on releasing the option to disable the RAID engine on Smart Array controllers to us plebs, it's easy enough to set them into non-RAID mode on Itanium based Integrity machines but on Xeon based ProLiants it's not possible and to use generic SSDs that would be the best option. The RAID intelligence of the controller just gets in the way with SSDs. There may be an option to use a JBOD controller in a slot and skip past HP's controller on boot by having nothing connected to it.
0
 

Author Comment

by:JohnnyD74
ID: 39745384
Dear Andrew,

Thank you so much for your very informative and detailed post! A few questions:

1. What is the rough cost of the FusionIO IO-DriveDuo 640GB card?
2. Is the idea that I use the card INSTEAD of drives or in addition to?
3. Would it be overkill to run the SQL server on a separate host AND use the card?

Thanks!
0
 

Author Comment

by:JohnnyD74
ID: 39745413
Andrew....one more question. What about a dedicated DL380P SQL server running 2 SSD's in Raid1? Do you think RAID1 would give the same SSD issues you mentioned in your post?
0
 
LVL 118
ID: 39745414
1. $15k, smaller units are available, and also OCZ now also produce similar cards, although not sure if these have hit the VMware HCL as yet.

2. there is no requirement to use any disks for storage as the PCI-E card, is 640GB of Flash Storage, for use a a  VMFS datastore for all your VMs. But you could use standard disks and create a datastore, and split the OS Drive and Database drive for DB and Logs on Flash. We actually use the entire flash datastore for VMs.

3. If you want even better performance, a physical host and Fusion-IO card will give even more performance.
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 118
ID: 39745421
We have yet to find a successful combination using consumer SSDs and HP Smart Array controllers, and HP Support are little help in our labs, which we would consider stable for customer and production usage.

We've had some success using non-HP storage controllers (LSI), but the RAID storage controller BIOS clash with the HP Smart Array controller BIOS, so we are not able to configure RAID types.

You would need to test your combination of consumer SSD and Smart Array controller, and as HP seem to be closing the gap shortly on firmware updates, support seems to be getting more difficult on using non-HP parts in HP Servers! (which I suppose is to be expected, why would you want to use a desktop SSD in a server in the datacentre?)
0
 

Author Comment

by:JohnnyD74
ID: 39745427
Thanks!!! That is good to know. Given my budget, I think I will simply go with 4 15K drives in RAID 10 and a dedicated DL380P host for the SQL machine. Do you think that will give me decent performance? I will only have 4-6 users connecting to the machine but want it do respond to queries as fast as possible.
0
 
LVL 118
ID: 39745814
I think that will give you ample performance.
0
 

Author Closing Comment

by:JohnnyD74
ID: 39746360
Thank you for your clear feedback, Andrew!
0
 
LVL 118
ID: 39746421
No problems, and Happy New Year 2014!
0

Featured Post

Are your corporate email signatures appalling?

Is it scary how unprofessional your email signatures look? Do users create their own terrible designs and give themselves stupid job titles? You can make this a lot easier for yourself by choosing an email signature management solution from Exclaimer today.

Join & Write a Comment

Will try to explain how to use the VMware feature TAGs in the VMs and create Veeam Backup Jobs using TAGs. Since this article is too long, I will create second article for the Veeam tasks.
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now