Solved

SQL 2008, RAID & VM WAre

Posted on 2011-09-28
5
471 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 121
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 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 121

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

Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

Question has a verified solution.

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

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
In this article, I will show you HOW TO: Create your first Windows Virtual Machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, the Windows OS we will install is Windows Server 2016.
Teach the user how to edit .vmx files to add advanced configuration options Open vSphere Web Client: Edit Settings for a VM: Choose VM Options -> Advanced: Add Configuration Parameters:
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…

724 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