Downloaded 12 times
![Pricing Models DTU/vCore [single database] eDTU/vCore [elastic pool] Hyperscale (Preview)](https://image.slidesharecdn.com/successfullymigratingexistingdatabasestoazureppt-191007083844/75/Successfully-migrating-existing-databases-to-Azure-12-2048.jpg)
Uploaded byRed Gate Software
Successfully migrating existing databases to Azure
The document outlines a presentation on successfully migrating databases to Azure SQL Database, led by John Sterrett. It covers the planning, execution, and management phases of migration, including budget considerations and the advantages of leveraging PaaS solutions. Additionally, it provides insights into performance monitoring, compatibility issues, and essential tools for migration and database management.
Successfully migrating existing databases to Azure
- 1. Topics Click toedit Master text styles • Second level • Third level − Fourth level • Fifth level Successfully migrate existing databases to Azure SQL Database John Sterrett Principal Consultant
- 2. Common Migration failures PlanTest Execute Manage
- 3. Free Reference Material Videos,ReferenceLinks,Tips, and slide deck can be found at procuresql.com/azure-migration-resources/
- 4. Agenda • Where ShouldMy DataGo? • How do I plan asuccessfulmigration? • How to migrate myData? • How to leverage PaaSBenefits? • What am I responsible for PostMigration (DoesDBAJobgo away)?
- 5.
- 6. Three reasons people aremigrating? 6
- 7. Cost Comparison 7 Qty ItemCost TotalCost FiveYears TenYears 2PowerEdgeR9302xE7-8893v4 (16cores) 54,224.05 $108,448.10 $21,689.62 $10,844.81 8SQL2016 Enterprise Cores(2 CorePack) 14,256.00 $114,048.00 $22,809.60 $11,404.80 Support Power $222,496.10 $44,499.22 $22,249.61 4PowerEdgeR9302xE7-8893v4 (16cores) 54,224.05 $216,896.20 $43,379.24 $21,689.62 16SQL2016 Enterprise Cores(2 CorePack) 14,256.00 $342,144.00 $68,428.80 $34,214.40 Support Power $559,040.20 $111,808.04 $55,904.02 Monthly Yearly Premium Elastic Database -eDTU250 1,398.72 $16,784.64 Support(Standard) 300.00 $3,600.00 Power $0.00 $20,384.64 Premium Elastic Database - eDTU1500 8,370.00 $100,440.00 Support (ProfessionalDirect) 1,000.00 $12,000.00 $112,440.00 P11Single Database 7,001.04 $84,012.48 Support (ProfessionalDirect) 1,000.00 $12,000.00 $96,012.48
- 8. Security Enhancements Firewall Secure Connections DataIn Flight DataAt RestAudit Threat Detection
- 9. Azure SQL Features… Security AzureData Sync Active Geo- Replicas Performanc e Insight Automate d Tuning Intellect Query Processing
- 10.
- 11. Where Should MyData Go? Single Databas e (PaaS) Elastic Pool (PaaS) Managed Instance (PaaS) SQLVM(IaaS)
- 12.
- 13. What problems doesHyperscale Solve? • What ishyperscale? • It’s anew storage architecture for cloud scaledatabases • Query engine is not changed. • Manage Very LargeDatabases (VLDBs)without the headache of VLDB’s! • Support to 100TB+sizedatabases • Restore VLDB’sin minutes not hours. (snapshots to blobstorage) • Low latency, high throughput disk I/O • Limitations asof 6/1/19? • Doesn’t support Managed Instances or ElasticPools • Migration is one way. Cannot go back without BACPAC • Video: Kevin Farlee at SQLBitson Hyperscale • BOL:Hyperscale with 100TB+ database
- 14. What is DTU? ImageSource: Microsoft Docs
- 15. DTU vs vCore? ImageSource: Microsoft Docs
- 16. vCore to DTUratio • Each100DTU in Standard tier requires at least 1vCore inGeneral Purpose tier • Each125DTU in Premium tier requires at least 1vCore inBusiness Criticaltier
- 17. Pricing DTU vsvCore
- 18. What performance tiershould we use? Dtucalculator.azurewebsites.net
- 19.
- 20. How you shouldfind the right performance tier
- 21. How do yousuccessfully Migrate Databases? 22
- 22. Migrating Your DataToAzure SQL Database +Schema Data Migration=
- 23. Options to MoveYour Data… BACKPAC Transactional Replication DataMigration Service RestoreBackup (Managed Instance) Log Shipping/A G (VM)
- 24. Migrating to AzureSQL Database AssessDB (DMA) Prepare Fixes Implement Fixes Export Bacpac Import Bacpac https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate/
- 25. Migrate Schema withData Migration Assistant
- 26. Select Tables toMove
- 27.
- 28.
- 29. Migrate with Dbatools.io(my favorite)
- 30. How do Imake my migration go faster?
- 31. Easy Guide toQuickly Migrating Data Increas e Tier CopyData Reduc e Tier
- 32. Migrating 60GB Databasewith S0 33
- 33. Migrating a 60gbDatabase to P1 34
- 34. Overloading during BulkInsert 35
- 35. How do youmanage Azure SQL Databases Today? 36
- 36. Biggest Database ManagementMistake.. Create it and forgetit…
- 37. Manage Azure SQLDB Post Migration Business continuity Disaster Recovery Security and Compliance SyncData DataTransfer Monitor and Improve Performance
- 38. High Availability withFailover Groups
- 40. Azure Database Maintenance •Integrity Checks source • Backups • Restores (you control) • Point in Time • Deleted Database • GeoRestore • Index Maintenance • OlaHallengren Solution Works;-) • Statistics Maintenance • GeoReplication / Failover Groups
- 41. Automating Maintenance Tasks •AzureSQLAgent (Managed Instance & VMOnly) • Linked Server • PowerShell • Azure • AzureAutomation • AzureFunctions • Azure Elastic Jobs
- 42.
- 43. How do youmonitor and improve performance?
- 44. DTU Is….. DTU =DTUPercent* DTU Limit
- 45. Calculating DTU ISNULL( dt u _ l imi t , 0) * (SELECT Max(v) FROM (VALUES (avg_cpu_percent), (avg_data_io_percent), ( avg_log_write_percent ) ) AS value( v) ) / 100.0 AS DTU
- 46. SYS.DM_DB_RESOURCE_STATS User Database Captured EveryFifteenSeconds OneHour Historical Data Idle Database hasData
- 47. SYS.RESOURCE_STATS Master Database EveryFive Minutes 14DaysHistorical Data Idle databases may not haverows
- 48.
- 49.
- 50. Azure SQL DatabaseWaits IO_QUEUE_LIMIT Disk Usage LogUsage LOG_RATE_GOVERNOR CPU SOS_SCHEDULER_YIELD bit.ly/azureSQLWaits
- 51.
- 52. Indexes in AzureSQL Database Automated CreateIndex Automated Drop Index Index Fragmentation Missing Indexes Index Usage Querie s Missing Indexes
- 53.
- 54. Azure SQL DatabaseTuning Tools
- 55. Azure SQL DatabasePerformance Tools Query Store DMVs Extended Events AzurePortal Query Performanc e Insight Auto-Tuning Index
- 56.
- 57. • FreeHelpful Content •http://azuresqldbresources.procuresql.com/ Thank you! john@procuresql.com @johnsterrett johnsterrett.com procuresql.com linkedin.com/in/johnsterrett