Infrastructure for Microsoft SQL Server Financial Services Case Study Ross Mistry Principal Enterprise Architect Microsoft Corporation MTC Silicon Valley Manjnath Ajjampur Lead Datacenter Strategist Northern California ID: 724468
Download Presentation The PPT/PDF document "Designing a Private Cloud" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Designing a Private Cloud Infrastructure for Microsoft SQL Server: Financial Services Case Study
Ross Mistry Principal Enterprise ArchitectMicrosoft Corporation: MTC – Silicon Valley
Manjnath Ajjampur
Lead Datacenter Strategist, Northern CaliforniaMicrosoft Corporation
DBI318Slide2
Ross
Mistry
@
RossMistry
http://RossMistry.com
Principal Enterprise Architect, Author and former SQL Server MVP
Microsoft Technology Centers – Silicon ValleySlide3
Manjnath Ajjampur
@
InADatacenter
Lead Datacenter Strategist, Northern California
Microsoft CorporationSlide4
AgendaIntroduction
Private Cloud OverviewPlanningDesignOptimizationSlide5
Part 1
Private Cloud OverviewSlide6
Pooled
Resources
Self-Service
Usage-based
Elastic
Microsoft Private Cloud Defined
“A private cloud is a new model for IT delivery. It turns a datacenter’s infrastructure resources into a single compute “cloud” and enables the key benefits of cloud
computing:Slide7
Agility
Economics
Innovation
Cloud DriversSlide8
Part 2
Private Cloud Customer PlanningSlide9
Existing Environment
Hundreds of Instances of SQL Server running on physical servers
OS memory range: 4GB-48GBApproximately 2000 DatabasesMajority of the servers were running Windows Server 2008 or Windows Server 2008 R2Leveraging some System Center within other groups2U rack mounted servers – underutilizedSAN based storageSeparation of duties - DBA and Server Platform EngineeringSlide10
Customer Goals and Requirements
Business drivenVirtualize Tier 2 and 3 data platform environments. Increase manageability by standardizing on single data platform and OS.
Reduce TCO and increase hardware utilization.Implement self service capabilities .Dynamically support projected growth of 30% per year.
Allow DBA and Server teams to be proactive and focus on
strategy.
Adhere to green
initiatives.
Technology driven
Pool key resources (compute, storage and networking) into logical units.
Dynamically provision and scale database applications.
Provide high availability and disaster recovery for mission critical databases.Slide11
Planning – Resource Pooling
Used the MAP Toolkit to identify SQL Server sprawl.Leveraged the data from MAP for Private Cloud capacity planningUsed the Upgrade Advisor to analyze SQL Server instances and identify upgrade blockersCaptured the following performance metrics Processor
Memory Disk Space and I/OTempDB usage
MAP Toolkit
Upgrade advisorSlide12
Key Findings from MAP & Metrics Collected
Systems were running with <10% CPU utilization on 4 to 8 core machinesMemory Usage per instance was approximately
2 to 64 GB Total storage required was approximately 5 TBIOPs ranged from 30 -10,000Slide13
Reviewing a Sample MAP ReportSlide14
Part 3
Private Cloud Customer Design DecisionsSlide15
Design Decisions - Overall
Virtualize Tier 2 and 3 databases - 100 Instances on Hyper-VStandardize on SQL Server 2008 R2 on Windows Server 2008 R2 SP1Private Could based on Windows Server 2008 R2 (Server Core) and Systems Center 2012
Database Migration for existing workloads6 Nodes in Hyper-V ClusterHA at a VM level, not instance level1 SQL Server instance per VMManagement infrastructure not part of this cluster
Segregation between Hyper-V platform owners and DBAs Slide16
Design Decisions - Processor
Total cores required –300 – this will be based on how many instances we go afterCurrent utilization – <10% of the CPU on an 8
core machine.Rationalization 2 socket servers with 8 cores per socketConservative 8:1 overcommit ratio of
vCPU:CPU provided by Hyper-V100 instances with 1 core dedicated to each will require 100 coresBest PracticesSelecting the maximum number of cores per processor available and choosing the fastest clock speed available.Slide17
Design Decisions - Memory
Assuming a 4GB per VM average, and a no oversubscription, that is ~130GB per node. Each node has 384 GB RAM
Dynamic Memory Utilized for all workloadsBest Practicesrecommended to purchase the maximum amount of RAMRespect NUMA architecture Slide18
Design Decisions - Storage
Use Pass-through disks for maximum performanceUse Storage Classification to adhere to business SLAOS will boot from SAN8GB Fibre ChannelBest Practices
Each storage OEM has their own design recommendations for Hyper-V optimizationRespect SQL server LUN best practiceSlide19
Design Decisions - Network
Follow Hyper-V best practice1 network for Management traffic1 network for Live Migration1 network for Cluster interconnect1-5 networks for SQL Server VM trafficSQL Server VM traffic is over highly available and redundant NICs (802.3 ad)
Hardware based QOSSlide20
Part 4
Optimizing SQL Server in a Private CloudSlide21
High Availability and Disaster Recovery
1 SQL Server instance per VMHA at the VM level using Live MigrationDR via SAN replicationSlide22
Alternatives
SQL Server High AvailabilitySlide23
SQL Server HA Alternatives in Private CloudLive Migration
No Loss of ServiceAvailability with Lower ComplexityEasier Management with VMM
Manage Loads on VMs Across Physical Machines
1
2
VM
Shared Storage
iSCSI, SAS, Fiber
Host cluster
Live
MigrationSlide24
SQL Server HA Alternatives in Private CloudGuest Clustering
Create failover cluster in Hyper-V environment
Cluster service runs inside Hyper-V guestApplication Mobility: Enable patching of guest OS without downtimeSupport mixed clustering (
host and guest)
Shared Storage
iSCSI
Guest Cluster
Guest Cluster
1
2
Redundant
Paths to storageSlide25
SQL Server HA Alternatives in Private CloudAvailability Groups
Guest Clustering not RequiredAchieve HA and DRNo 3
rd Party Solutions Required
1
2
VMs
2Slide26
Self-Service 3 x SQL Server Service Templates for Provisioning
Small – 1 vCPU, 4GB RAM, 100 GB, >1000 IOPS Medium – 2 VPs, 8 GB RAM, 200 GB, >1000 IOPS Large – 4 VPs, 16 GB RAM, 400 GB,
>5000 IOPS Slide27
SQL Server Service TemplatesSlide28
Track Resources
@sqlserver
@ms_teched
m
v
a
Microsoft Virtual Academy
SQL Server 2012 Eval Copy
Get Certified!
Hands-On LabsSlide29
Resources
Connect. Share. Discuss.
http://northamerica.msteched.com
Learning
Microsoft Certification & Training Resources
www.microsoft.com/learning
TechNet
Resources for IT Professionals
http://microsoft.com/technet
Resources for Developers
http://microsoft.com/msdn Slide30
Required Slide
Complete an evaluation on CommNet and enter to win!Slide31
MS Tag
Scan the Tag
to evaluate this
session now on
myTechEd
MobileSlide32
©
2012 Microsoft
Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part
of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation.
MICROSOFT
MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.Slide33