Virtualizing SQL Server with VMware (häftad)
Fler böcker inom
Format
Häftad (Paperback)
Språk
Engelska
Antal sidor
512
Utgivningsdatum
2014-07-25
Upplaga
1
Förlag
VMware Press
Medarbetare
Szastak, Jeff / Webster, Michael
Illustrationer
illustrations
Dimensioner
234 x 177 x 31 mm
Vikt
793 g
Antal komponenter
1
ISBN
9780321927750

Virtualizing SQL Server with VMware

Doing IT Right

Häftad,  Engelska, 2014-07-25

Slutsåld

The start-to-finish guide to virtualizing business-critical SQL Server databases on VMware vSphere 5

By virtualizing business-critical databases, enterprises can drive far more value from existing IT infrastructure. But squeezing maximum performance out of a virtualized database instance is an art as much as a science. This indispensable start-to-finish guide brings together all the techniques, tips, and insights you need to succeed.

Drawing on unsurpassed personal experience, three leading experts share complete best practices for deploying business-critical database servers in virtualized vSphere 5 environments. They cover the entire project lifecycle, bridging technical and communications gaps between SQL Server and VMware professionals that often make database virtualization more difficult than it needs to be.

Youll find specific guidance for architects and administrators responsible for systems, storage, databases, applications, or VMware virtualization. The authors also present detailed, start-to-finish coverage of performance baselining and testing: all you need to make your virtualized databases as fast as they are cost effective. Although this book focuses on SQL, the authors proven guidance for enhancing performance can be leveraged by any IT professional virtualizing a demanding Tier 1 application.

Coverage includes

Business cases for database virtualization: consolidation, Database as a Service (DaaS), efficiency, and SLAs on steroids

Using the redundancy inherent in virtualization to improve availability

Constructing a careful, conservative implementation plan

Balancing disk, CPU, memory, and network for superior performance

Mastering the five key principles of database storage design

Leveraging memory: SQL MAX, page locking, NUMA, reservations, swapping, large memory pages, and more

Ensuring responsiveness by providing a fast, reliable, low-latency network

Supporting advanced AlwaysOn Failover Cluster Instances and Availability Groups

Baselining physical systems and properly determining resource requirements

Configuring performance tests from beginning to end

Migrating existing SQL Server databases onto a vSphere platform

Avoiding traps and pitfalls in virtualizing production databases

Managing and monitoring virtualized database instances and resources
Visa hela texten

Kundrecensioner

Har du läst boken? Sätt ditt betyg »

Fler böcker av Michael Corey

  • Job, Jonah, and the Unconscious

    Michael Corey

    Job, Jonah, and the Unconscious is the latest work by natural theologian M.A. Corey. It is a ground-breaking synthetic work utilizing the unique perspective of modern depth psychology to interpret the underlying meaning of two of the most fascinat...

  • Bayou Mystere

    Michael Corey

    Mickey McGuire, alongside his cousin Richard, are on a trek through a Louisiana bayou when they stumble across the body of a murdered Black man. The event pursues Mike into his adult life working as an executive recruiter, when he is hired to sear...

Övrig information

Michael Corey (@Michael_Corey) is the President of Ntirety, a division of Hosting. Michael is an experienced entrepreneur and a recognized expert on relational databases, remote database administration, and data warehousing. Microsoft named Michael a SQL Server MVP, VMware named him a vExpert, and Oracle named him an Oracle Ace. Michael has presented at technical and business conferences from Brazil to Australia. Michael is a past president of the Independent Oracle Users Group; he helped found the Professional Association of SQL Server, is a current board member of the IOUG Cloud SIG, and is actively involved in numerous professional associations and industry user groups. Michael currently sits on the executive committee for the Massachusetts Robert H. Goddard Council for Science, Technology, Engineering, and Mathematics. Jeff Szastak (@Szastak) is currently a Staff Systems Engineer for VMware. Jeff has been with VMware for over six years, holding various roles with VMware during his tenure. These roles have included being a TAM, Systems Engineer Specialist for Business-Critical Applications, Enterprise Healthcare Systems Engineer, and a CTO Ambassador. Jeff is a recognized expert for virtualizing databases and other high I/O applications on the vSphere platform. Jeff is a regular speaker at VMworld, VMware Partner Exchange, VMware User Groups, and has spoken at several SQL PASS events. Jeff holds a Master of Information Assurance degree as well as the distinguished CISSP certification. Jeff has over 13 "lucky" years in IT and is passionate about helping others find a better way to do IT. Michael Webster (@vcdxnz001) is based in Auckland, New Zealand. He is a VMware Certified Design Expert (VCDX #66), author of longwhiteclouds. com (a top-15 virtualization blog), and a Top 10 Vmworld Session Speaker for 2013. In addition, he is a Senior Solutions and Performance Engineer for Nutanix, vExpert, MCSE, and NPP. Michael specializes in solution architecture and performance engineering for Unix-to-VMware migrations as well as virtualizing business-critical applications such as SQL, Oracle, SAP, Exchange, Enterprise Java Systems, and monster VMs in software-defined data centers. Michael has more than 20 years experience in the IT industry and 10 years experience deploying VMware solutions in large-scale environments around the globe. He is regularly a presenter at VMware VMworld, VMware vForums, VMware User Groups, and other industry events. In addition to this book, Michael was technical reviewer of VCDX Boot Camp and Virtualizing and Tuning Large-Scale Java Platforms, both published by VMware Press.

Innehållsförteckning

Foreword xvii

Preface xix

About the Authors xxiii

About the Technical Reviewer xxv

Acknowledgments xxvii

Reader Services xxix

1 Virtualization: The New World Order? 1

Virtualization: The New World Order 1

 Virtualization Turns Servers into Pools of Resources 3

 Living in the New World Order as a SQL Server DBA 3

 A Typical Power Company 6

Summary 7

2 The Business Case for Virtualizing a Database 9

Challenge to Reduce Expenses 9

The Database Administrator (DBA) and Saving Money 10

Service Level Agreements (SLA) and the DBA 11

 Avoiding the Good Intention BIOS Setting 12

DBAs Top Reasons to Virtualize a Production Database 13

 High Availability and Database Virtualization 14

 Performance and Database Virtualization 16

 Provisioning/DBaaS and Database Virtualization 17

 Hardware Refresh and Database Virtualization 20

Is Your Database Too Big to Virtualize? 22

Summary 23

3 Architecting for Performance: The Right Hypervisor 25

What Is a Hypervisor? 25

 Hypervisor Is Like an Operating System 26

 What Is a Virtual Machine? 28

 Paravirtualization 29

The Different Hypervisor Types 29

 Type-1 Hypervisor 30

 Type-2 Hypervisor 31

Paravirtual SCSI Driver (PVSCSI) and VMXNET3 31

Installation Guidelines for a Virtualized Database 32

 Its About Me, No One Else But Me 33

 Virtualized Database: Its About Us, All of Us 34

 DBA Behavior in the Virtual World 34

 Shared Environment Means Access to More If You Need It 35

 Check It Before You Wreck It 36

Why Full Virtualization Matters 36

 Living a DBAs Worst Nightmare 37

Physical World Is a One-to-One Relationship 38

 One-to-One Relationship and Unused Capacity 38

 One to Many: The Virtualized World 40

 The Right Hypervisor 40

Summary 41

4 Virtualizing SQL Server: Doing IT Right 43

Doing IT Right 43

The Implementation Plan 44

 Service-Level Agreements (SLAs), RPOs, and RTOs 45

 Baselining the Existing vSphere Infrastructure 46

 Baselining the Current Database Workload 48

Birds-Eye View: Virtualization Implementation 50

 How a Database Virtualization Implementation Is Different 51

Summary 55

5 Architecting for Performance: Design 57

Communication 58

 Mutual Understanding 59

 The Responsibility Domain 60

Center of Excellence 61

Deployment Design 63

SQL Workload Characterization 64

 Putting It Together (or Not) 65

 Reorganization 68

 Tiered Database Offering 70

Physical Hardware 73

 CPU 74

 M...