Solved

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

Posted on 2011-09-23
4
286 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
4 Comments
 
LVL 119

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Server configuration for MS Access - SQL Server app 8 71
View SQL 2005 Job package 16 43
Unified EndPoint Management 1 26
VMWare 6.5 5 56
When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
Teach the user how to delpoy the vCenter Server Appliance and how to configure its network settings Deploy OVF: Open VM console and configure networking:
Teach the user how to use configure the vCenter Server storage filters Open vSphere Web Client:  Navigate to vCenter Server Advanced Settings: Add the four vCenter Server storage filters: Review the advanced settings: Modify the values of the four v…

777 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