?
Solved

SQL 2008, RAID & VM WAre

Posted on 2011-09-28
5
Medium Priority
?
474 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 123
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 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 123

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
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…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

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