Prueba

Microsoft® SQL Server on VMware® Best Practices Guide

Microsoft SQL Server on VMware Best Practices Guide

© 2010 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. This product is covered by one or more patents listed at http://www.vmware.com/download/patents.html. VMware, VMware vSphere, VMware vCenter, theVMware “boxes” logo and design, Virtual SMP and vMotion are registered trademarks or trademarks of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

VMware, Inc 3401 Hillview Ave Palo Alto, CA 94304 www.vmware.com

© 2010 VMware, Inc. All rights reserved. Page 2 of 35

Microsoft SQL Serveron VMware Best Practices Guide

Contents
1.
1.1 1.2 1.3 1.4

Introduction .................................................................................. 4
Overview ........................................................................................................................ 4 Purpose.......................................................................................................................... 4 Target Audience ............................................................................................................. 5 Scope ............................................................................................................................. 5

2.
2.1 2.2 2.3 2.4 2.5

VMware ESX Host Best Practices for SQL Server ....................... 6General Guidelines ........................................................................................................ 6 CPU Configuration Guidelines ....................................................................................... 6 Memory Configuration Guidelines.................................................................................. 8 Storage Configuration Guidelines................................................................................ 10 Networking Configuration Guidelines .......................................................................... 17

3.
3.1 3.2 3.3

SQL Server Performance on vSphere ........................................ 18
Single Virtual Machine Performance Relative to Native .............................................. 19Multiple Virtual Machine Performance and Scalability ................................................. 20 Ongoing Performance Monitoring and Tuning ............................................................. 21

4.
4.1 4.2 4.3 4.4 4.5 4.6

Migrating SQL Server to vSphere .............................................. 23
Representative CustomerData.................................................................................... 23 Understand Database Workloads ................................................................................ 25 Understand Availability and Recovery Requirements.................................................. 25 Capture Resource Utilization Baseline for Existing Databases ................................... 27 Plan the Migration........................................................................................................ 27 Understand Database Consolidation Approaches ....................................................... 28

5.
5.1 5.2 5.3 5.4 5.5 5.6

vSphere Enhancements for Deployment and Operations........... 31
VMware vMotion, VMware DRS, and VMware HA ...................................................... 31Templates .................................................................................................................... 32 VMware vCenter Lab Manager .................................................................................... 32 VMware vCenter AppSpeed ........................................................................................ 33 VMware vCenter Site Recovery Manager...