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...
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...
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.
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...