Fast Start for Microsoft Azure SQL Server Iaa

Fast Start for Microsoft Azure SQL Server Iaa. S Delivery Readiness Training Blair Shaw Sr. Business Program Manager MCS App. Plat Team

Objectives 12/12/2021 • Industry Trends and SQL on Cloud OS • SQL on Azure Iaa. S Fast Start • Engagement Delivery 2

DATA EXPLOSION Industry Trends CONSUMERIZATION OF IT PRIVATE AND PUBLIC CLOUD Hosted Onpremises Virtualized Private Cloud • Digital data will grow 44 x over the next decade (2009 -2020)1 • By EOY 2014 60% of primary databases expected to be virtualized 2 • Public cloud services will account for 46% of net-new growth in IT spending in 2015 3 1 IDC Digital Universe Study, sponsored by EMC, May 2010. Week 2012 State of Database Technology Survey of 760 business technology professionals 3 IDC, Worldwide and Regional Public IT Cloud Services 2011 – 2015 Forecast, Doc #228485, June 2011 2 Information 12/12/2021 3

Hybrid Cloud SQL Server Cloud Continuum Paa. S Dedicated Higher cost Virtual Physical Saa. S Microsoft Azure SQL Database Iaa. S Database Services SQL Server in WA VM Virtualized Machines SQL Server Private Cloud Virtualized Machines+ Appliances SQL Server Physical Machines (raw iron) High Control 12/12/2021 Off premises Shared Lower cost On premises Low Control 4

Key Scenarios Delivery Options SQL Server and Azure SQL Database Public Cloud SQL Server in a Microsoft Azure Virtual Machine Move Existing Tier Two and Three Apps Develop and Test Backup Database to the Cloud Extend On-Premises Apps to Microsoft Azure Virtual Machine Microsoft Azure SQL Database (Formerly SQL Azure Database) Develop New Cloud-Designed Apps Extend On-Premises Apps to Microsoft Azure SQL Database Can Use both SQL Server in Microsoft Azure Virtual Machine and Microsoft Azure SQL Database in a single app.

SQL Server OLTP in Microsoft Azure VMs Scenarios • Dev/Test, big and small • Lift & Shift • • Fastest time to solution - On-ramps to full Saa. S Departments cutting the cord with central IT for B 2 B Inexpensive hosting alternative with pay per minute Cloud based learning/pre-sales demonstration • Hybrid • Iaa. S cross-premises Share. Point • Cloud DR, on-demand cloud bursting • Emerging scenarios taking advantage of pay per min price elasticity 12/12/2021 6

Backup & Restore to Cloud Low TCO for Existing Apps RESTORE IN AZURE VIRTUAL MACHINE Microsoft Azure DIRECT URL BACKUP TO AZURE BLOB STORAGE Full SQL Server Capability SQL Server Management Studio SQL Server in VM On-Prem SQL Server Note : SQL Server 2005, 2008/2008 R 2 backup is done on file system and copied to Azure blob storage. Then the backup is restored within SQL Server instance on Microsoft Azure VM 12/12/2021 Flexibility & Control Managed Infrastructure 7

Extend on-prem apps to Microsoft Azure Virtual Machine Microsoft Azure Extend SQL Server in VM Microsoft Azure Virtual Network ON-PREM Note : On-premises business application can access SQL Server instance deployed in Microsoft Azure VMs Connect Business App SQL Server 12/12/2021 8

P 2 V Non-Virtualized 12/12/2021 Windows Server Hyper-V VHD OPTION 2 Database Virtual Machine Full SQL Server Capability V 2 V VHD Low TCO for Existing Apps OPTION 1 Move Existing Tier 2 & 3 Apps Flexibility & Control Virtualized Managed Infrastructure 9

Microsoft Azure SQL Database (Paa. S) SQL Server on Microsoft Azure Platform Comparison Target organizations • Startup-mode dev organizations • Elasticity and flexibility, low friction • Application compatibility • Existing enterprise customers • Traditional workloads Operations + Management • Mostly auto-administered • Reduced surface for Insights • Great single database • Requires effort for multi-db Availability • 99. 9% availability SLA • Requires development efforts if you • (Almost) all the option of the box • Requires infrastructural effort for full • Shared Resources • Requires scaling out • Predictable performance • May be limited by hw resources • Limited application compatibility • Mostly transparent • Can be more challenging to scale out Performance + Scalability Migration effort from on premises Costs 12/12/2021 SQL Server in WA VMs (Iaa. S) need more issues • May require effort in case of scaling out • Optimized for low costs to buy and manage HA if a single node is not enough • Licensing and VM costs may not be trivial 10

1 Architecture: SQL Server in Microsoft Azure VMs 2 ROLE VIRTUAL MACHINE C: OS Disk D: Resource Disk Dynamic VHD E: , F: , etc. Data Disks IMPLICIT CLOUD SERVICE VM No SLA RAM Cache Microsoft Azure Storage Blob 3 IMPLICIT CLOUD SERVICE Availability Set Primary Secondary VM VM SLA 99. 95 Microsoft Azure Storage Blob (somewhere else) Local Disk Cache Blobs 12/12/2021 Blob 11

Deploy SQL Server OLTP in Microsoft Azure VMs 12/12/2021 Use the Gallery image Bring your own image • Currently: SQL 2008 R 2 SP 2, SQL 2012 SP 1, SQL 2014 on different Windows Server OS • Upload VHD to WA storage account, use image to instantiate VM • Default options • Use Sysprep to create template • Includes SSIS, RS, AS • SQL Server 2008 and up • License: Multiple SKUs + Pay by Minute • License Mobility with Software Assurance • Image refreshed monthly (approximately) • You create image, patch, and manage • Once deployed you patch and manage 12

Microsoft Azure VM Sizes (Standard Tier) Virtual Machine Size CPU Cores Memory A 0 (Extra Small) Shared 768 MB 127 GB OS 20 GB Temp 1 1 x 500 A 1 Small 1 1. 75 GB 127 GB OS 70 GB Temp 2 2 x 500 A 2 Medium 2 3. 5 GB 127 GB OS 135 GB Temp 4 4 x 500 A 3 Large 4 7 GB 127 GB OS 285 GB Temp 8 8 x 500 A 4 Extra Large 8 14 GB 127 GB OS 605 GB Temp 16 16 x 500 A 5 2 14 GB 127 GB OS 135 GB Temp 4 4 x 500 A 6 4 28 GB 127 GB OS 285 GB Temp 8 8 x 500 A 7 8 56 GB 127 GB OS 605 GB Temp 16 16 x 500 Source: http: //msdn. microsoft. com/en-us/library/windowsazure/dn 197896. aspx 12/12/2021 Maximum IOPS (500 maximum per disk) Disk Size for Maximum Virtual data disks (1 Machines TB each) Pricing: http: //azure. microsoft. com/en-us/pricing/calculator/? scenario=virtual-machines ü Auto-scaling ü Load balancing 13

Microsoft Azure VM Sizes (Basic Tier) Virtual Machine Size CPU Cores Memory A 0 (Extra Small) Shared 768 MB 127 GB OS 20 GB Temp 1 1 x 300 A 1 Small 1 1. 75 GB 127 GB OS 40 GB Temp 2 2 x 300 A 2 Medium 2 3. 5 GB 127 GB OS 60 GB Temp 4 4 x 300 A 3 Large 4 7 GB 127 GB OS 120 GB Temp 8 8 x 300 A 4 Extra Large 8 14 GB 127 GB OS 240 GB Temp 16 16 x 300 Source: http: //msdn. microsoft. com/en-us/library/windowsazure/dn 197896. aspx Pricing: http: //azure. microsoft. com/en-us/pricing/calculator/? scenario=virtual-machines 12/12/2021 Maximum IOPS (500 maximum per disk) Disk Size for Maximum Virtual data disks (1 Machines TB each) Auto-scaling Load balancing 14

Microsoft Azure VM Pricing Virtual Machines http: //azure. microsoft. com/enus/pricing/calculator/? scenario=virtual-machines http: //azure. microsoft. com/en-us/pricing/details/virtualmachines/#windows With SQL http: //azure. microsoft. com/enus/pricing/calculator/? scenario=virtual-machines http: //azure. microsoft. com/en-us/pricing/details/virtualmachines/#sql-server Pricing frequently changes, please visit the pricing details links above to review the current pricing options 12/12/2021 15

Stock. Trader Demo Move DB to Azure SQL Iaa. S Lap Around Windows Azure SQL Database and Microsoft SQL Server in Windows Azure Virtual Machines Stock. Trader Demo Extracted from DBI-B 201 Greg Leake – Technical Product Manager http: //channel 9. msdn. com/Events/Tech. Ed/North. America /2013/DBI-B 201? format=auto#time=43 m 07 s 12/12/2021 16

Backup to URL Demo Platform for Hybrid Cloud with SQL Server 2014 - Channel 9 Backup is an essential task for every DBA. SQL Server provides a great mechanism to back up databases from SQL Server 2005, 2008 R 2, 2012, and 2014 to Azure cloud storage, easily and seamlessly. Xin Jin, Program Manager SQL Backup to URL on Azure Storage [01: 44] http: //channel 9. msdn. com/Series/Platform-for-Hybrid-Cloud-with -SQL-Server-2014/01 12/12/2021 17

Backup using Azure Backup Tool Platform for Hybrid Cloud with SQL Server 2014 - Channel 9 Backup is an essential task for every DBA. SQL Server provides a great mechanism to back up databases from SQL Server 2005, 2008 R 2, 2012, and 2014 to Azure cloud storage, easily and seamlessly. George Li, Program Manager SQL [08: 29] - Backup to Windows Azure Tool https: //channel 9. msdn. com/Series/Platform-for-Hybrid-Cloudwith-SQL-Server-2014/01 12/12/2021 18

Primary Objectives 12/12/2021 ü Introducing customer to the basics of deploying SQL Server instances and understanding the requirements for SQL Server running on Iaa. S ü Backup on Microsoft Azure Storage ü Assistance on creating and deploying SQL Server on Iaa. S ü Offered as either a 1 day or 3 day Fast Start Delivery 19

Offering Activities and Timeline 1 Day Delivery PRE-ENGAGEMENT Day 1 Understand customer environment Fast Start for Microsoft Azure - SQL Server Iaa. S Workshop slides (6 hrs) Assign Premier Resources SQL Azure Iaa. S and hybrid cloud Demonstration (1 hr) SQL backup and restore to Azure Storage Demonstration ( 1 hr) 12/12/2021 20

Offering Activities and Timeline 3 Day Delivery PRE-ENGAGEMENT Day 1 Day 2 Day 3 Understand customer environment Fast Start for Microsoft Azure - SQL Server Iaa. S Workshop slides (6 hrs) Complete Lab: Install Applications and SQL database on Azure Iaa. S (2 hrs) Make it POC by migrating an existing SQL database to Azure Iaa. S Assign Premier Resources SQL Azure Iaa. S and hybrid cloud Demonstration (1 hr) SQL backup and restore to Azure Storage Demonstration (1 hr) Fast Start Closeout Lab: Install Applications and SQL database on Azure Iaa. S (1 hr) Lab: Backup databases to Azure Storage and restore (3 hrs) Prepare for day 3 Identify database (2 hrs) 12/12/2021 21