High availability for Azure SQL Managed Instance with a DEMO

Learn about high availability (HA), how it's designed and achieved for General Purpose (GP) and Business Critical (BC) services tiers of Azure SQL Managed Instance. We'll also explain in this video how Zone Redundancy fits into the HA story. We'll also show a demo of how an Azure SQL Managed Instance failover event (a restart) affects an application with built-in retry logic. See the demo to find out what was the duration of down time for GP and BC. We'll show another demo - how a scaling operation that's changing SQL MI service tier, vCore count and reserved storage size affects the application using the SQL MI.

Video by Uros Milanovic.

Chapters:
00:08 HA for SQL MI introduction
01:17 BC and GP service tier architecture and HA
02:55 Zone Redundancy (Availability Zones)
03:32 The scope of high-availability
05:24 Demo - how failover of GP and BC service tier impact the application
06:10 What was the down-time for GP and BC?
06:25 User initiated actions that cause a failover (a restart)
07:08 Demo - changing service tier, vCore count and reserved storage
08:15 Demo - how SQL MI scaling operation affects the application
09:35 Conclusion and key takeaways

📩 SQL MI Newsletter | https://aka.ms/sqlmi-letter
🍿 Watch next | What is and how to configure maintenance window https://www.youtube.com/watch?v=n9cNTuBeTd0
📚 Read next | What’s new in SQL Server and Azure SQL: 2023 Year in Review | https://techcommunity.microsoft.com/t5/azure-sql-blog/what-s-new-in-sql-server-and-azure-sql-2023-year-in-review/ba-p/3981926

Recommended content:
High availability for Azure SQL Managed Instance: https://learn.microsoft.com/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql
Overview of business continuity with Azure SQL Managed Instance: https://learn.microsoft.com/azure/azure-sql/managed-instance/business-continuity-high-availability-disaster-recover-hadr-overview?view=azuresql
Zone Redundancy for SQL MI: https://aka.ms/sqlmi-zr
What is Azure SQL Managed Instance: https://learn.microsoft.com/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview
What's new in Azure SQL Managed Instance: https://learn.microsoft.com/azure/azure-sql/managed-instance/doc-changes-updates-release-notes-whats-new?view=azuresql
A summary of Azure SQL Managed Instance product updates in 2023: https://aka.ms/sqlminov23

Тэги:

#Azure_SQL_Managed_Instance #Azure_SQL #high_availability #retry_logic #failover #restart #SQL #SQL_Server #general_purpose #business_critical #service_tier #demo #scaling_operation #zone_redundancy #HA #BC #GP #SQLMI #SQL_MI

Скачать видео