/
Designing a Private Cloud Designing a Private Cloud

Designing a Private Cloud - PowerPoint Presentation

celsa-spraggs
celsa-spraggs . @celsa-spraggs
Follow
349 views
Uploaded On 2018-11-09

Designing a Private Cloud - PPT Presentation

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

sql server private microsoft server sql microsoft private cloud resources storage hyper cluster design part service windows decisions corporation

Share:

Link:

Embed:

Download Presentation from below link

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.


Presentation Transcript

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