1 / 35

Provisioning SQL Database-as-a-Service in the Azure Pack

Learn all about Database-as-a-Service (DBaaS) in Azure Pack, tenant database creation, AlwaysOn, Resource Governor, and more. Explore multi-tenant management and integration options.

petes
Download Presentation

Provisioning SQL Database-as-a-Service in the Azure Pack

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Provisioning SQL Database-as-a-Service in the Azure Pack RupiSureshkumar BRK3501

  2. Agenda Overview of DBaaS and the Azure Pack Tenant database creation Required steps in Azure Pack AlwaysOnand Resource Governor Common Questions

  3. What is the Azure Pack? Self-service based on Microsoft Azure Web Sites Apps Database VMs Services Plans Users Automation Tenant Site Admin Site Multi-tenant IaaS and PaaS Service Management API Offer management Database SQL SeverMySQL CustomResource Providers • VMs, • Networks, • Automation Web Sites Service Bus Usage tracking Automation w/ Service Provider Foundation & Service Management Automation Portal integration and branding

  4. What is Database-as-a-Service? Cloud-based rapid provisioning of databases in the context of a database cloud rather than in the context of individual servers

  5. Who wants this?

  6. 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 it

  7. Database provider • Automated • Placement 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 subscription • Can bill for different types of databases created and amount of space consumed

  8. DBaaS Options Multi-tenant DBaaS SQL Server in a VM WAP SQL Resource Provider Private Cloud Public Cloud

  9. Demo

  10. Let’s set this all up.

  11. 4. Tenant subscribes to Plan and creates databases Tenant Subscription Plan 3. Create Plans and include Editions Plan Plan 2. Create Server Groups in WAP 1. Set up SQL fabric

  12. Demo

  13. Integrating advanced SQL capabilities

  14. 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 Clusters

  15. Demo

  16. 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 WAP

  17. Demo

  18. Common questions

  19. So…does this require System Center? • For advanced capabilities, System Center is what provides automation, monitoring, IaaS etc. • However, for simple DBaaS, all you need is WAP + SQL Server

  20. 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 enabled

  21. 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 server

  22. 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 Pack

  23. How can I automate my environment? Service Management Automation: installed with Azure Pack to automate management tasks Administrator creates runbooksusing PowerShell Workflow to complete routine and common tasks Out-of-box sample: Sample-Managing-SQLServers

  24. Can I use other database providers too? • 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 template • Custom resource providers are possible for other providers

  25. What about Azure Stack?! • Azure Pack continuously supported and enhanced thru 2017

  26. 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!

  27. 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/WAPjumpstart Community Links on TechNet Wiki http://aka.ms/WAPwiki

  28. 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 DBaaSWhite Paper http://blogs.technet.com/b/privatecloud/archive/2014/05/06/enabling-database-as-a-service-with-the-microsoft-private-cloud-stack.aspx

  29. Related Content: Breakout Sessions

  30. Related Content: Labs Instructor-led Labs Hands-on Labs

  31. Learn more with FREE IT Pro Resources Free technical training resources: On-demand online training: http://aka.ms/moderninfrastructure 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 Expand your Modern Infrastructure Knowledge 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 Join the IT Pro community: Twitter @MS_ITPro

  32. 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 9th, 2015. For Official Rules, see The Cloud and Enterprise Lounge or myignite.com/challenge

  33. Please evaluate this session Your feedback is important to us! VisitMyigniteathttp://myignite.microsoft.comor download and use the Ignite Mobile Appwith the QR code above.

More Related