1/17/2014

1

SQL Server Virtualization 101

David Klee, Group Principal and Practice Lead

SQL Saturday Nashville, 2014.01.18

www.linchpinpeople.com 1

www.linchpinpeople.com 2

David Klee

@kleegeek

davidklee.net

gplus.to/kleegeek

linked.com/a/davidaklee

Specialties / Focus Areas / Passions:

• Performance Tuning &

Troubleshooting

• Virtualization

• Cloud Enablement

• Infrastructure

Architecture

• High Availability

• Disaster Recovery

• Health Monitoring

• Capacity Management

• Data Processing

Group Principal and Practice Lead

1/17/2014

2

Agenda

• What is Virtualization?

• Why Virtualize?

• Infrastructure Underneath

• Benefits for DBAs

• Benefit Examples

www.linchpinpeople.com 3

VirtualizationVirtualizationVirtualizationVirtualization

www.linchpinpeople.com 4

What Is It?

1/17/2014

3

What is Virtualization?

• Added layer between hardware and operating system

• Hardware treated as physical resource queues

• Extension of the hardware, so is treated as part of the platform

• Not just P2Ving a single server…

• Most DBA’s virtualization experience…

www.linchpinpeople.com 5

Terminology

www.linchpinpeople.com 6

• Virtual Machine / Guest

• Hypervisor

• Physical Machine / Host

• Template

• Cloud (Public / Private)

• Over-Committed

• Consolidation

• Live Migration / vMotion

1/17/2014

4

Traditional Computing

www.linchpinpeople.com 7

Local Disks (OS, Instance Home)

SQL Server A

SQL Server B

SQL Server C

(10% utilization)

(12% utilization)

(15% utilization)

8

Virtualization Computing

VIR

TU

ALI

ZAT

ION

VM

VM

VM

www.linchpinpeople.com

(75% utilization)

1/17/2014

5

Why Virtualize?Why Virtualize?Why Virtualize?Why Virtualize?

www.linchpinpeople.com 9

And Why Should DBAs Care?

Business Cases

• Reduced costs

• Datacenter efficiency, consolidation & simplification

• Increased agility, flexibility, & responsiveness

• Business continuity

• Software development lifecycle

• Automation

• Simplified management

• Security

www.linchpinpeople.com 10

1/17/2014

6

How Does It Help DBAs?

• High Availability & Disaster Recovery

• Snapshots for system-state rollback

• Capacity management - quickly

• Less downtime with equipment upgrades or maintenance

• Ease administration

• Cloning & templates

• Standardization

• Better Performance

www.linchpinpeople.com 11

How Does It Hurt DBAs?

• One extra layer

• Not dedicated infrastructure resources

• Lack of infrastructure-level visibility

• Silent performance killers

• Insufficient physical resources

• Poor performance

• FUD!

www.linchpinpeople.com 12

1/17/2014

7

InfrastructureInfrastructureInfrastructureInfrastructure

www.linchpinpeople.com 13

What is Underneath Your Data

In The Beginning…

• Virtualization’s historical draw is datacenter consolidation

• Extremely high overhead from virtualization layer

• Virtualize Dev / Test / QA

• Virtualize tiny / simple Production

• Low resource allocations to VMs

• Performance impact rarely mattered

www.linchpinpeople.com 14

1/17/2014

8

Today’s Technologies

• Virtualize everything – Tier-1 production

• Almost zero virtualization overhead

• Extremely mature technologies

• Easy to configure and manage

• Virtual storage, networking, security

• Infinitely scale the datacenter

• Public / private / hybrid cloud models

www.linchpinpeople.com 15

Hypervisor Options (Q1 2014)

VMware vSphere 5.5

(ESXi + vCenter)

Microsoft Hyper-V 2012 R2

(Hyper-V + SCCM + SCVMM)

www.linchpinpeople.com 16

1/17/2014

9

vSphere 5.5 & Hyper-V 2012 R2

• 64 vCPUs / 1TB vRAM

• 62TB x 180 virtual disks

• 62TB Raw Device Maps

• HA & Load Balancing

• 399 OSs Supported

• vCenter included

www.linchpinpeople.com 17

VMware vSphere 5.5 Microsoft Hyper-V 2012 R2

• 64 vCPUs / 1TB vRAM

• 64TB x 256 virtual disks

• 256TB Pass-Through Disks

• HA & Load Balancing

• 46 OSs Supported

• Need System Center & SCVMM

Virtualization Cluster

www.linchpinpeople.com 18

V I R T U A L I Z A T I O N

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

VM

SAN

Disk

PoolVMware ESXi

MS Hyper-V

1/17/2014

10

Central Management

www.linchpinpeople.com 19

VIR

TU

ALI

ZAT

ION

VM

VM

VM

Inter-Node

Communication

VMware vCenter /

MS SCVMM

20

Logical Cluster Model

150 GHz

CPU4 TB

Memory

4x10GbE

Network

20 TB

Tier 1

Storage

40 TB

Tier 2

Storage

VM

16 vCPU

128 GB vRAM

VM

8 vCPU

64 GB vRAM

VM2 vCPU

16 GB

vRAM

VM2 vCPU

16 GB

vRAM

VM2 vCPU

16 GB

vRAM

VM2 vCPU

16 GB

vRAM

VM2 vCPU

16 GB

vRAM

VM2 vCPU

16 GB

vRAM

V I R T U A L I Z A T I O N

www.linchpinpeople.com

1/17/2014

11

Resource & Performance Statistics

• Get read-only access to virtualization performance statistics for your VMs

www.linchpinpeople.com 21

Benefits for DBAsBenefits for DBAsBenefits for DBAsBenefits for DBAs

www.linchpinpeople.com 22

Get The Most From Virtualization

1/17/2014

12

High Availability

© 2013 Heraflux Technologies 23

Disaster Recovery

www.linchpinpeople.com 24

Virtualization Virtualization

SQL

Server

VM A

SQL

Server

VM A’

App

Server

VM B

App

Server

VM B’

WAN

Pri

ma

ry S

ite

DR

Sit

e

15 minute replication

60 minute replication

1/17/2014

13

Snapshots

www.linchpinpeople.com 25

Capacity Management

www.linchpinpeople.com 26

1/17/2014

14

Templates & Cloning

• Build master ‘gold’ VM template

• Deploy new VM from template in minutes (vs. days)

• Configuration standardization guaranteed

www.linchpinpeople.com 27

Benefit ExamplesBenefit ExamplesBenefit ExamplesBenefit Examples

www.linchpinpeople.com 28

Benefits Go Beyond the Obvious

1/17/2014

15

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

• Destroy the VMs when complete

www.linchpinpeople.com 29

CERTIFIED RECOVERY

Performance 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?

30www.linchpinpeople.com

1/17/2014

16

Performance Benefit Example (2)

• Collocate two VMs on the same host to increase virtual network performance

www.linchpinpeople.com 31

Conclusions

• 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 possibly improve performance

www.linchpinpeople.com 32

1/17/2014

17

Questions?Questions?Questions?Questions?

33

@kleegeek

davidklee.net

gplus.to/kleegeek

linked.com/a/davidaklee

www.linchpinpeople.com

Thank You!Thank You!Thank You!Thank You!

www.linchpinpeople.com 34