?
Solved

SQL 2008, RAID & VM WAre

Posted on 2011-09-28
5
Medium Priority
?
481 Views
Last Modified: 2016-12-08
Hi All,

I am used to working with physical SQL servers, configuring different RAID packs for logs, OS & data files etc.

I am now faced with a VM Ware server that I wish to put SQL 2008 on, the host that I wish to install this SQL instance on is connected to a SAN through a datastore specifically for the SQL build I am configuring.  The SAN uses RAID 50.

My question is this - do I need to worry about th RAID configuration within the virtual server, do I need a datastore for logs and a datastore for database files - or does VM Ware decide this intelligently (even if I had two datastores they could over-lap onto the same disk).

Thanks

0
Comment
Question by:techmiss
5 Comments
 
LVL 126
ID: 36717788
What you need to ensure is that you have a very fast underlying datastore to present to the ESXi server.

So ensure you configure as many disks as possible in a RAID 10, for optimum read and write performance for all virtual machine disks, that are stored on the datastore. All virtual machines will then benefit from the fast datastore.

More disks = more spindles = more IOPS = more performance.

0
 
LVL 43

Accepted Solution

by:
kevinhsieh earned 1000 total points
ID: 36717859
If the SAN only has a single tier of storage, there is nothing you can do performance wise regarding the disks because everything will end up on the same tier anyway. It is still a good idea to have separate volumes for the databases and logs, but that is for management purposes. so, if you have just 1 tier of stoarage put the logs and databases onto separate VMDKs on your datastore(s). IO for virtualized environments is all random by the time it hits the storage layer, so adding more random database IO hopefully isn't going to be an issue for the SAN.  
0
 
LVL 40

Expert Comment

by:lcohan
ID: 36717924
Here's RAID50 explained however as "kevinhsieh" mentioned if you have only one LUN available then don't need to wory about anything else but different folders for different SQL files because your SAN will take care of the rest. Memory is one other thing you need to make sure is enough available for your VM running the SQL Server(s).

http://www.iscsi-raid.com/raid50.html
0
 
LVL 126

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 1000 total points
ID: 36718017
0
 

Author Closing Comment

by:techmiss
ID: 36890477
Hi Guys,

Thanks, thats pretty much what I figured - I will have to read through the best practices guide in detail.

Split the points as you were both of assistance.

Thanks
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
Teach the user how to configure vSphere Replication and how to protect and recover VMs Open vSphere Web Client: Verify vsphere Replication is enabled: Enable vSphere Replication for a virtual machine: Verify replicated VM is created: Recover replica…
Teach the user how to use vSphere Update Manager to update the VMware Tools and virtual machine hardware version Open vSphere Client: Review manual processes for updating VMware Tools and virtual hardware versions: Create a new baseline group in vSp…
Suggested Courses
Course of the Month3 days, 23 hours left to enroll

599 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