Rupi Sureshkumar BRK3501 Agenda Overview of DBaaS and the Azure Pack Tenant database creation Required steps in Azure Pack AlwaysOn and Resource Governor Common Questions What is the Azure Pack ID: 358827
Download Presentation The PPT/PDF document "Provisioning SQL Database-as-a-Service i..." 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.
Slide1Slide2
Provisioning SQL Database-as-a-Service in the Azure Pack
Rupi Sureshkumar
BRK3501Slide3
Agenda
Overview of DBaaS
and the Azure Pack
Tenant database creation
Required steps in Azure Pack
AlwaysOn
and Resource Governor
Common QuestionsSlide4
What is the Azure Pack?
w
/ Service Provider
Foundation
& Service Management Automation
VMs,
Networks,
Automation
Service
Bus
Database
SQL Sever
MySQL
Web
Sites
Service Management API
Services
Plans
Users
Automation
Admin Site
Tenant
Site
Web Sites
Apps
Database
VMs
Custom
Resource
Providers
Self-service based on Microsoft Azure
Multi-tenant IaaS and PaaS
Usage tracking
Automation
Offer management
Portal integration and brandingSlide5
Cloud-based rapid provisioning of databases in the context of a database cloud rather than in the context of individual servers
What is Database-as-a-Service?Slide6
Who wants this?Slide7
Database consumer
On-demand
Quick access to a database allows for greater agility and innovation
Simple
No need to manage a full server
Abstracted
from management of
HA,
performance
Cost-efficient
Pay for what you use, when you use itSlide8
Database provider
Automated
P
lacement
algorithm determines best placement for database
Extensible
Can combine WAP with existing integrations or your own customization to provide unique experience for tenants
Billable
Usage data reported for each tenant subscriptionCan bill for different types of databases created and amount of space consumedSlide9
DBaaS Options
Public Cloud
Private
Cloud
SQL Server in a VM
Multi-tenant
DBaaS
WAP SQL Resource ProviderSlide10
DemoSlide11
Let’s set this all up.Slide12
1. Set up SQL fabric
2. Create Server
Groups
in WAP
3. Create
Plans
and include
Editions
4. Tenant subscribes to Plan and creates databases
Plan
Plan
Plan
Tenant SubscriptionSlide13
DemoSlide14
Integrating advanced SQL capabilities Slide15
SQL Server AlwaysOn
Availability Group is container for multiple server instances
Primary replica is read-write while secondary replicas are read-only
Manual or automatic failover possible when primary goes down
Dependency on Windows Server Failover ClustersSlide16
DemoSlide17
Performance Isolation using Resource Governor
Specify resource consumption limits on incoming requests across CPU, Memory, IOPs
Avoid
noisy neighbor syndrome
where one tenant can consume all server resources at detriment of others
Databases are managed in context of the resource pool they are in, instead of the whole server
Constraints of the Resource Pool are mapped to editions in WAPSlide18
DemoSlide19
Common questionsSlide20
For advanced capabilities, System Center is what provides automation, monitoring,
IaaS etc.However, for simple DBaaS, all you need is WAP + SQL Server
So…does this require System Center?Slide21
What versions of SQL are supported?
Support for
SQL Server 2008 SP3
SQL Server 2008 R2 SP2
SQL Server 2012
SP1 (min. req. for HA)
SQL Server
2014 (min. req. for Resource Governor)Should have SQL authentication enabledSlide22
What is the allocation algorithm?
Database is placed on a server that supports the requested edition and has enough capacity.
Will fill a server before allocating to a new server
Resource Governor databases spread more evenly as all databases in same subscription will be kept on the same serverSlide23
How can I monitor my environment?
Operations Manager can be used to monitor your
DBaaS
solution
Alerts created when issues arise in environment
Windows Azure Pack Management Pack
SQL Server Management PackSlide24
How can I automate my environment?
Service Management Automation: installed with Azure Pack to automate management tasks
Administrator creates
runbooks
using PowerShell Workflow to complete routine and common tasks
Out-of-box sample: Sample-Managing-
SQLServersSlide25
Out of the box, Azure Pack comes with SQL and MySQL Resource Providers
If using SQL-in-a-VM approach, Oracle is available as a templateCustom resource providers are possible for other providers
Can I use other database providers too?Slide26
Azure Pack continuously supported and enhanced thru 2017
What about Azure Stack?!Slide27
Summary
Azure Pack can be used to provide Database-as-a-Service with SQL Server
Administrator creates different options via editions
Integrate with other products for better administrative experience
Support for:
Windows Authentication
Contained Database creation
AlwaysOn (HA)Resource Governor… and more!Slide28
More about Windows Azure Pack
WAP Product Overview
http://aka.ms/WAPoverview
WAP Customer Feedback
http://aka.ms/WAPfeedback
WAP Partner Links
http://aka.ms/WAPpartners
WAP Jump Start Session http://aka.ms/WAPjumpstartCommunity Links on TechNet Wiki http://aka.ms/WAPwikiSlide29
More about Windows Azure Pack DBaaS
WAP SQL RP Documentation
https://
technet.microsoft.com/en-us/library/dn469317.aspx
WAP SQL MVA Course
http://www.microsoftvirtualacademy.com/training-courses/windows-azure-pack-database-as-a-service-dbaas
WAP
DBaaS White Paper http://blogs.technet.com/b/privatecloud/archive/2014/05/06/enabling-database-as-a-service-with-the-microsoft-private-cloud-stack.aspxSlide30
Related Content: Breakout Sessions
Day
Timeslot
Title
Wednesday 5/6
10:45 – 12:00
Windows Azure Pack Roadmap
9:00 – 10:15
Overview of the Microsoft Cloud Platform System
1:30 – 2:45
Expanding the Microsoft Cloud
Platform with the Windows Azure Pack and Partners
Thursday 5/7
10:45 – 12:00Windows Azure
Pack and Microsoft System Center: Monitoring and Requests for Service Providers
1:30 – 2:45Azure IaaS for Azure Pack (Azure Stack)
1:30 – 2:45Managing Linux Workloads in Windows Server, System Center and the Azure Pack
3:15 – 4:30
Troubleshooting Windows Azure Pack Providers
Friday 5/89:00 – 10:15
Extending Virtual Machines in the Windows Azure Pack
10:45 – 12:00
Taking advantage of Identity capabilities in the Azure PackSlide31
Related Content: Labs
Title
Introducing the
Windows Azure Pack
Installing and Configuring the
Windows Azure Pack
Managing
Infrastructure-as-a-Service with the Windows Azure PackUsing Service Management Automation in the Windows Azure PackUsing Virtual Machine Roles in the Windows Azure PackDayTimeslotTitle
Thursday 5/73:15-4:30Introducing the Windows Azure Pack
Instructor-led Labs
Hands-on Labs Slide32
Learn more
with FREE
IT Pro Resources
Free technical training resources:
On-demand online training:
http://aka.ms/moderninfrastructure
Expand your
Modern
Infrastructure Knowledge
Free
ebooks
:
Deploying Hyper-V with Software-Defined
Storage
& Networking:
http://aka.ms/deployinghyperv
Microsoft System Center: Integrated Cloud Platform:
http://aka.ms/cloud-platform-ebook
Join the IT Pro community:
Twitter
@
MS_ITPro
Get hands-on: Free virtual labs:
Microsoft Virtualization with Windows Server
and
System Center:
http://aka.ms/virtualization-lab
Windows Azure Pack: Install and Configure:
http://aka.ms/wap-lab Slide33
Ignite Azure
Challenge Sweepstakes
Attend Azure sessions and activities, track your progress online, win raffle tickets for great prizes!
Aka.ms/
MyAzureChallenge
Enter this session code online
: BRK3501
NO PURCHASE NECESSARY. Open only to event attendees. Winners must be present to win. Game ends May 9
th
, 2015. For Official Rules, see The Cloud and Enterprise Lounge or myignite.com/challengeSlide34
Visit
Myignite
at
http://myignite.microsoft.com
or download and use the
Ignite
Mobile
App
with
the QR code above.
Please evaluate this session
Your feedback is important to us!Slide35