Solved

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

Posted on 2011-09-23
4
296 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 121

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

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
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:
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

696 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