DBI 321 Microsoft SQL Server Database Private Cloud

DBI 321 Microsoft SQL Server Database Private Cloud Deep Dive Danny Tambs Managing Architect, APJ

Location: http: //h 20195. www 2. hp. com/V 2/Get. PDF. aspx/4 AA 4 -2741 ENW. pdf

Organizations are struggling to break free Silos and sprawl create complexity Solutions are costly and time-consuming to deploy Can’t access actionable insight quickly Systems are complex, inefficient to operate No single view of the business Information is hard to access and use Volume, variety and velocity of data is growing Too much time spent wrangling all the pieces

Microsoft Private Cloud Capabilities Resource Pooling Consolidate Databases Challenge Elasticity Scale Resource Efficiently Solution Challenge • Microsoft Assessment and Planning Toolkit • Database sprawl discovery (MAP) • Windows Server 2008 R 2 Hyper-V Live • Minimize planned downtime Migration • Microsoft Consolidation Planning Toolkit for • Capacity planning Solution SQL Server • Manage unplanned downtime • Guest Failover Clustering with • Windows Server 2008 R 2 • SQL Server 2008 R 2 • Maximize virtual machine density • Windows Server 2008 R 2 SP 1 • Hyper-V with Dynamic memory • Virtual machine load balancing • System Center Virtual Machine Manager • Microsoft SQL Server 2008 R 2 Upgrade • Migration planning Advisor • SQL Server Migration Assistant • System Center Virtual Machine Manager • Physical to virtual migration 2008 R 2 • Windows Server 2008 R 2 Hyper-V • System Center Virtual Machine Manager • Virtualize and manage instances 2008 R 2 Self-Service Control & Customize Deploy Resources On-Demand Challenge • Standardize server builds Drive Standardization and Compliance Solution Challenge • System Center Virtual Machine Manager 2008 R 2 VM Templates • Automate server provisioning • System Center Virtual Machine Manager 2008 R 2 Self-Service Portal 2. 0 Solution • Measure usage • Assign cost per VM template • Usage reporting • Charge back reporting • System Center Virtual Machine Manager • Manage private cloud • System Center Virtual Machine Manager 2008 R 2 Self-Service Portal 2. 0 R 2 • System Center Operations Manager 2007 R 2 • Management Packs Source: NIST definition of Cloud Computing (www. nist. gov )

MS/HP DBC Reference Architecture Complete • Factory built and pretested Optimize • Central console to simplify management Virtualization to pool and • Tuned for SQL Server I/O improve resource • Migrate databases and utilization update infrastructure with • Consulting and support near zero downtime services • Agile • Provision SQL on demand • Meter and chargeback usage • Modular, scale as your business grows Insight Control

Vision Box Product What we know today, Custom solutions. Appliances / Reference Architectures Either buy premade, or build your own The Cloud Azure PDW Fast Track RA DBC RA

DBC RA and HP Virtual Systems VS 1 DBC RA Database Server Consolidation Application Server Consolidation VS 2… VS 3

DBC Reference Architecture Consolidate and provision SQL server in a private cloud Base Full configuration • Implement in weeks vs months • Provision databases in minutes vs weeks • 75% operational expense savings • Consolidate 1000’s of databases • 60, 000 IOPS sustained / rack HP Pro. Liant BL 465 with P 2000 storage (… 10)

6 months + Fast implementation means fast benefits Factory built and tuned for performance Self-build DBC reference architecture Design solution Buy assembled hardware RFP Install & configure software Build hardware Start consolidating Build software Assemble Install software Test Tune and update Start consolidating Weeks Faster time to value

Deploy with Confidence Workload requirements – Proven infrastructure built on best practices of leading experts – Secure, compliant infrastructure for fewer vulnerabilities Reference architecture – Single, trusted source of support for simpler resolution – Built in SCOM for managing the Infra. Server, storage, networking Application software Integrated and optimized by HP and MS experts Tested Tuned – DPM for doing backups – HA built into the DBC RA Pre-configured and ready to run Single source for support Validated

Reduce TCO and scale to 1000’s of databases Unprecedented ROI to customers … Base configuration 100 -200 VMs Reduce cost 35% Full configuration Multi-rack Thousands of VMs 200 -400 VMs Drive Green IT: in the first year Energy 90% Cooling 95% Floor space 89% Administration 75%

DBC Reference Architecture Product architecture

DBC RA Hardware Design Base Configuration 2 x Pro. Curve E 6600 10 Gbps switches 2 x Pro. Curve E 2910 1 Gpbs switches 4 servers 8 cpu 1 TB RAM 28 TB raw capacity 198 spindles 30, 000 IOPs HP C 3000 Enclosure with Flex-10 4 x BL 465 c G 7 Blades (2 P) • 256 GB RAM • 2 x 300 GB HDD 2 x Storage Blocks Storage Block: 1 x P 2000 Disk Array 3 x D 2700 Disk Racks (99 spindles in block) Full Configuration 8 servers 16 cpu 192 cores 2 TB RAM 57 TB raw capacity 396 spindles 60, 000 IOPs 4 x Storage Blocks 8 x BL 465 c G 7 Blades (2 P) • 256 GB RAM • 2 x 300 GB HDD

DBC reference architecture scales to 10 racks Add half rack or full rack modules Base configuration + Add half rack Or add full rack Half up to 10 racks HP E 6600 10 Gbps switches HP E 2910 1 Gbps switches = C 3000 enclosure (4 -80) blade servers (2 -40)storage blocks–each w/: 27 TB – 570 TB raw capacity up to 600 K IOPS

DBC RA Management Software Stack Applications monitoring Applications deployment and patch management OS Monitoring of guests – hosts Patch management of guests - hosts Management of Hyper-V VMs Migration of workloads Monitoring HW alerts Insight Control

DBC Software Stack – MS Products In Detail – Management Server (Multiple VMs on blades) • Windows Server 2008 R 2 Data Center Edition – Active Directory, DNS, HDCP, Hyper-V Roles • Microsoft Assessment Planning (MAP) toolkit • SQL Server 2008 R 2 Data Center Edition • System Center Configuration Manager R 2 • System Center Operations Manager • System Center Virtual Machine Manager 2008 R 2 • Virtual Machine Manager Self-Service Portal v 2. 0 SP 1 • System Center Service Manager • Orchestrator Previously known as Opalis (for MAP workflow) – Blades • Windows Server 2008 R 2 Data Center Edition – Hyper-V Role • Guest Virtual Machines • Small, Medium & Large VM Templates • SQL Server instances that are virtualized from existing customer installation • SQL Server 2008 R 2 Data Center Edition

DBC Storage Connectivity Hardware Architecture Blade Enclosure KEY: Blade Base RA Blade Add’l for Full Rack Blade 2 VC Ports 2 2 2 10 Gb. E Switch P 2000 MSA 3 P 2000 MSA D 2700 JBOD 3 P 2000 MSA 3 D 2700 JBOD User Workloads VC Ports

Existing Servers Windows Server, Hyper-V, System Center VMM VM P 2 V Migration Server #1 VM VM P 2 V Migration Server #2 P 2 V M SQL Server Std 2008 igratio VM SQL Server EE 2005 n Server #3 VM SQL Server 2008 Std R 2 VM Newly created VMs. Use existing ‘IT template’ VMs. Room to grow Bank of VMs VM 1 VM 2 VM 3

Front Back

P 2000 D 2700

General network traffic - Management • • • 2 × HP Pro. Curve E 2910 1 G Used for Network Traffic inside the Rack Blades plug into customer network directly Connection to customer network through the switch is for management traffic only i. SCSI Storage traffic 2 × HP Pro. Curve E 6600 10 G • • Used for i. SCSI (storage) traffic All storage components and blades connected to this switch Redundant 10 Gb Connectivity to Network Core Switches HP Virtual Connect Flex-10 10 Gb Ethernet Module • • • Connected to E 2910 (internet) Connected to E 6600 (storage) Connected to customer network

Baseline for Sizing the Hardware and Solution Bundled SQL server database virtual machine templates Small – 55% • • 1 virtual processor 2 GB RAM 100 GB formatted disk space 50 IOPS / VM Medium – 35% • • 2 virtual processors 4 GB RAM 200 GB formatted disk space 400 IOPS / VM Large – 10% • • 4 virtual processors 16 GB RAM 400 GB formatted disk space 1600 IOPS / VM A single rack configuration is optimized for a balanced mix of about 200 database instances • Based on a mix of 128 small workloads, 48 medium workloads, and 16 large workloads – based on Microsoft and HP best practices • Customers with more small workloads can support more instances

VM Layout on Blades (1 & 2)

VM Layout on Blades (3 & 4)

Engineered with HA and DR ready Protect business-critical SQL server workloads High availability Disaster recovery • • Redundant network and storage infrastructure Host cluster for server level failover • Host backup / restore • Base level of VM HA leveraging failover clustering at the host level Live migrate all VMs to another node in the cluster while performing updates/patches on that host without impacting the running workloads • Guest backup / restore • SQL Server technologies, including: • Database mirroring • Log shipping • Replication • Backup / restore 3 rd-Party host-based clustering Blades • Guest • • Database Cluster SQL within the VMs for an additional level of granularity where necessary by leveraging VM guest clustering* Failover the SQL instance to another VM, and patch/update the guest OS in the first VM with no SQL downtime • *The DBC RA design is intended to support about 10 -15% of the VMs using guest clustering.

Networking – Connecting to customer Network redundancy using Link Aggregation Control Protocol (LACP)

Virtual Machines Hyper-V Virtual NICs Hyper-V Virtual Switches Production Backup HP NIC Teaming Instances Team Production Team Backup HP Virtual Connect Flex-NICs (4 Channels) Physical HP Flex-10 NIC with 2 Ports Note: Not all networks are represented

30, 000 Random IOPS per Half Rack 60, 000 Random IOPS per Full Rack

Virtual Connect Network Design 1 Gb 8 Gb 2 Gb

Storage Block Disk Architecture Can loose multiple disks with no data loss

DBC CSVs

http: //www. microsoft. com/en-us/server-cloud/windows-server/server-virtualization-features. aspx

MAP tool for Sizing and Planning • MAP tool discovers and profiles your SQL Server databases • MAP categorizes SQL instances by size (small, medium, large) • Intelligent framework for consolidation strategy

Provision SQL servers on demand Self service portal workflow engine manages and controls requests

Usage metering and chargeback Self service portal reports usage enables charge back by business units

HP DBC RA support Choose the service level from Microsoft and from HP to meet your business needs Microsoft Premier Support* − 24 x 7 reactive support with on-site response − Proactive services − Technical account management Premier mission critical All features of underlying premier plan above plus − Faster reactive support response time with on-site solution engineering support − Personalized coverage through designated support engineer − Solution supportability review and health checks for maximum performance HP Support Plus 24** − Reactive 24 x 7 hardware and software support for HP components with a 4 hr onsite hw response Proactive 24 Service or − The coverage of Support Plus 24, enhanced with account support manager delivered proactive services to improve IT stability or Critical service − Minimizes the business risk of downtime by enhancing proactive 24 services with support through the Global Mission Critical Solution Center (GMCSC) Critical Advantage or − Proactive mission critical support with access to the GMCSC and tailored to x 86 virtualized environments