Transcription
1/17/2014SQL Server Virtualization 101David Klee, Group Principal and Practice LeadSQL Saturday Nashville, 2014.01.18www.linchpinpeople.com1David KleeGroup Principal and Practice com/a/davidakleeSpecialties / Focus Areas / Passions: Performance Tuning &Troubleshooting Virtualization Cloud Enablement InfrastructureArchitecturewww.linchpinpeople.com High AvailabilityDisaster RecoveryHealth MonitoringCapacity ManagementData Processing21
1/17/2014Agenda What is Virtualization?Why Virtualize?Infrastructure UnderneathBenefits for DBAsBenefit Exampleswww.linchpinpeople.com3VirtualizationWhat Is It?www.linchpinpeople.com42
1/17/2014What is Virtualization? Added layer between hardware and operatingsystem Hardware treated as physical resource queues Extension of the hardware, so is treated as part ofthe platform Not just P2Ving a single server Most DBA’s virtualizationexperience www.linchpinpeople.com5Terminology Virtual Machine / GuestHypervisorPhysical Machine / HostTemplateCloud (Public / Private)Over-CommittedConsolidationLive Migration / vMotionwww.linchpinpeople.com63
1/17/2014Traditional ComputingLocal Disks (OS, Instance Home)SQL Server A(10% utilization)SQL Server B(12% utilization)SQL Server C(15% utilization)www.linchpinpeople.com7Virtualization Computing(75% .com84
1/17/2014Why Virtualize?And Why Should DBAs Care?www.linchpinpeople.com9Business Cases Reduced costsDatacenter efficiency, consolidation & simplificationIncreased agility, flexibility, & responsivenessBusiness continuitySoftware development lifecycleAutomationSimplified managementSecuritywww.linchpinpeople.com105
1/17/2014How Does It Help DBAs? High Availability & Disaster RecoverySnapshots for system-state rollbackCapacity management - quicklyLess downtime with equipmentupgrades or maintenanceEase administrationCloning & templatesStandardizationBetter Performancewww.linchpinpeople.com11How Does It Hurt DBAs? One extra layerNot dedicated infrastructure resourcesLack of infrastructure-level visibilitySilent performance killersInsufficient physical resourcesPoor performanceFUD!www.linchpinpeople.com126
1/17/2014InfrastructureWhat is Underneath Your Datawww.linchpinpeople.com13In The Beginning Virtualization’s historical draw is datacenterconsolidation Extremely high overhead from virtualization layer Virtualize Dev / Test / QA Virtualize tiny / simple Production Low resource allocations to VMs Performance impact rarely matteredwww.linchpinpeople.com147
1/17/2014Today’s Technologies Virtualize everything – Tier-1 productionAlmost zero virtualization overheadExtremely mature technologiesEasy to configure and manageVirtual storage, networking, securityInfinitely scale the datacenterPublic / private / hybrid cloud modelswww.linchpinpeople.com15Hypervisor Options (Q1 2014)VMware vSphere 5.5(ESXi vCenter)Microsoft Hyper-V 2012 R2(Hyper-V SCCM SCVMM)www.linchpinpeople.com168
1/17/2014vSphere 5.5 & Hyper-V 2012 R2VMware vSphere 5.5Microsoft Hyper-V 2012 R2 64 vCPUs / 1TB vRAM 62TB x 180 virtual disks 62TB Raw Device Maps HA & Load Balancing 399 OSs Supported64 vCPUs / 1TB vRAM64TB x 256 virtual disks256TB Pass-Through DisksHA & Load Balancing 46 OSs Supported Need System Center &SCVMM vCenter includedwww.linchpinpeople.com17Virtualization Mware ESXiMS Hyper-Vwww.linchpinpeople.comSANDiskPool189
1/17/2014Central ManagementVMware vCenter /MS w.linchpinpeople.com19Logical Cluster ModelVM8 vCPU64 GB vRAMVM16 vCPU128 GB vRAMVMVMVM2 vCPU16 GBvRAM2 vCPU16 GBvRAM2 vCPU16 GBvRAMVMVMVM2 vCPU16 GBvRAM2 vCPU16 GBvRAM2 vCPU16 GBvRAMV I R T U A L I Z A T I O N150 GHzCPU4 TB4x10GbEMemoryNetworkwww.linchpinpeople.com20 TBTier 1Storage40 TBTier 2Storage2010
1/17/2014Resource & Performance Statistics Get read-only access to virtualization performancestatistics for your VMswww.linchpinpeople.com21Benefits for DBAsGet The Most From Virtualizationwww.linchpinpeople.com2211
1/17/2014High Availability 2013 Heraflux Technologies23Disaster RecoverySQLServerVM ASQLServerVM A’15 minute replicationWANAppServerVM BAppServerVM B’60 minute replicationDR SiteVirtualizationPrimary SiteVirtualizationwww.linchpinpeople.com2412
1/17/2014Snapshotswww.linchpinpeople.com25Capacity Managementwww.linchpinpeople.com2613
1/17/2014Templates & Cloning Build master ‘gold’ VM template Deploy new VM from template in minutes (vs. days) Configuration standardization guaranteedwww.linchpinpeople.com27Benefit ExamplesBenefits Go Beyond the Obviouswww.linchpinpeople.com2814
1/17/2014Virtualization Benefit Example System backup and restore testing Restore your VM-level backups to a new VM on anoffline virtual network Clone domain controller into offline virtual network Power on everything Validate that the server comes up Now validate your SQL Server functionality Validate SQL Server-level backups Destroy the VMs when completeCERTIFIED RECOVERYwww.linchpinpeople.com29Performance Benefit Example (1) High transactional volume application? Long-running ETL data loads? iperf how-to guide:http://tinyurl.com/ost9gll Move a lot of data between two VMs?www.linchpinpeople.com3015
1/17/2014Performance Benefit Example (2) Collocate two VMs on the same host to increasevirtual network performancewww.linchpinpeople.com31Conclusions Don’t fear virtualization – embrace it(‘cuz it’s here to stay) Virtualize everything with confidence Revisit your operational procedures Smart architecture can simplify Smarter architecture can possiblyimprove performancewww.linchpinpeople.com3216
com33Thank You!www.linchpinpeople.com3417
Virtualization Benefit Example System backup and restore testing Restore your VM-level backups to a new VM on an offline virtual network Clone domain controller into offline virtual network Power on everything Validate that the server comes up Now validate your SQL Server functionality Validate SQL Server-level backups
