Solved

VMWare 4.x+ and busy SQL Server production - any case studies

Posted on 2011-09-23
4
292 Views
Last Modified: 2012-06-27
On the web, there is mixed opinion on putting busy sql server on VM environment. (slow testing environments- no problems)..

there is places where the products stated where with vmware less than 4 versions.. is there any case study of implentations of VMWare latest editions (4+) on production databases and what the results were?

thanks
0
Comment
Question by:25112
[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
4 Comments
 
LVL 120

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 167 total points
ID: 36587517
This is the Best Practice Guide
http://communities.vmware.com/docs/DOC-8964

But it's like ANY Server you virtualise, to test and make sure it is suitable for virtualisation. Many organisations have SQL servers virtualised.

http://blogs.vmware.com/vmtn/2007/11/white-paper-sql.html
http://scottf.wordpress.com/2007/02/09/sql-server-on-vmware-server/
0
 
LVL 8

Assisted Solution

by:dba2dba
dba2dba earned 166 total points
ID: 36589718
IMO there will surely be some performance hit by moving to a virtual environment.

However, Disk IO seems to be an important aspect to consider. You can get separate LUNs from storage for various database files inorder to have better IO performance.

Below is an interesting blog post:

http://matthensley.wordpress.com/2010/05/16/best-practices-and-considerations-for-virtualizing-microsoft-sql-server-on-vmware/

http://www.vmware.com/files/pdf/sql_server_virt_bp.pdf

Thanks,
0
 

Assisted Solution

by:wjvanaacken
wjvanaacken earned 167 total points
ID: 36817147
We have a large SQL install for a well known ERP.  The environment of the SQL server is:
- VMware ESXi 4.1 latest patches
- Host is quad quad core with 128GB, 10Gb FCoE for network and data
- VM has 13 hard drives (VMDks) on 10 LUNs connected using all 4 SCSI controllers, 48GB RAM 100% reserved, 8 vCPUs,
- Windows 2008 (non-SP1... trying to get development team to allow/test SP1)
- SQL 2008 with main single database configured into 8 segments allowing for SQL parallelism

Tips:
- Spread I/O load across all 4 SCSI controllers
- Reserve 100% of RAM (asuming Tier 1 server)
- Watch I/O load on SAN.  The 10 LUNs are across 60 spindles and will be moving to SSD within 3 months.
- Keep in mind VMDK locks (we use 1 logical drive per VMDK) and LUN level locks
- Look to get to ESXi 5 soon based on a LOT of storage improvements!
0
 
LVL 5

Author Comment

by:25112
ID: 36962578
thanks
0

Featured Post

Technology Partners: 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

Suggested Solutions

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.
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Teach the user how to rename, unmount, delete and upgrade VMFS datastores. Open vSphere Web Client: Rename VMFS and NFS datastores: Upgrade VMFS-3 volume to VMFS-5: Unmount VMFS datastore: Delete a VMFS datastore:
Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:

732 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