Solved

Large Database on virtualized SQL server 2008 (vmware)

Posted on 2010-08-25
7
417 Views
Last Modified: 2012-06-27
Industry experts seem to say that large databases (>500-800GB) should be placed on Raw Luns. Why? What happens if you just use a VMDK?
0
Comment
Question by:Johnjaysmith
[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
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 12

Assisted Solution

by:mcv22
mcv22 earned 50 total points
ID: 33525983
Using virtualization of any kind has a performance overhead. If performance is not a concern, virtual disks should suffice.
0
 

Author Comment

by:Johnjaysmith
ID: 33526081
So Raw Luns are not virtualized? What is their structure as opposed to a vmdk?
0
 
LVL 40

Assisted Solution

by:coolsport00
coolsport00 earned 200 total points
ID: 33526427
No...RDMs are pointers to LUNs... not actual virtual disks.

~coolsporr00
0
Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

 
LVL 28

Assisted Solution

by:bgoering
bgoering earned 250 total points
ID: 33526565
If you have no reason to cluster your sql server with some other physcial or virtual host, there is not any reason to use rdms. However, when allocating LUNs for your vmdk files normal database considerations apply. For example I will allocate a RAID 10 LUN to my ESX servers, and place database log datasets there. I use RAID 5 for about everything else.

As of VMware 3.5 there is not much difference in performance between rdms and vmdk files.

Good Luck
0
 

Author Comment

by:Johnjaysmith
ID: 33526953
Your question implied to me that clustering a sql server requires or does better with rdms (raw lun)?
Can you create a raid array with an rdms disk format?
0
 
LVL 40

Accepted Solution

by:
coolsport00 earned 200 total points
ID: 33526975
Again, an RDM is solely a "pointer file", nothing more. It "points" to LUN disks. So, to answer your question...yes. Your LUNs can be whatever RAID your SAN supports. RDM provides 'direct access' to your SAN, whereas a virtual disk (VMDK) is storage on a VMFS volume (datastore), which is more than likely a LUN on your SAN (but obviously doesn't have to be).

Hope that helps.
~coolsport00
0
 
LVL 28

Assisted Solution

by:bgoering
bgoering earned 250 total points
ID: 33526980
Yes, if you have a requirement to build a cluster that crosses physical host boundaries, could be virtual to physical, or virtual to virtual if each instance is on a seperate esx host server, you will need to use rdms for any luns to be shared between the servers. The local OS disks can be vmdks.

Creating the lun would be a function of your storage, create a lun like you would for anything in whatever raid format you want. When you present your lun to ESX, instead of adding it as a datastore to ESX, create the rdm link in the database  server configuration.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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 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…
Teach the user how to install and configure the vCenter Orchestrator virtual appliance Open vSphere Web Client: Deploy vCenter Orchestrator virtual appliance OVA file: Verify vCenter Orchestrator virtual appliance boots successfully: Connect to the …
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…

695 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