Solved

SQL 2008, RAID & VM WAre

Posted on 2011-09-28
5
450 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 119
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 42

Accepted Solution

by:
kevinhsieh earned 250 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 39

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 119

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 250 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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…
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
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…
Advanced tutorial on how to run the esxtop command to capture a batch file in csv format in order to export the file and use it for performance analysis. He demonstrates how to download the file using a vSphere web client (or vSphere client) and exp…

770 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