{"id":15859,"date":"2020-08-08T05:27:30","date_gmt":"2020-08-08T05:27:30","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=15859"},"modified":"2022-03-21T11:10:21","modified_gmt":"2022-03-21T11:10:21","slug":"high-availability-for-azure-sql-database","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/","title":{"rendered":"High availability for Azure SQL Database"},"content":{"rendered":"\n<p>This tutorial will help you know about the High availability for Azure SQL Database. The purpose of the high availability design in Azure SQL Database and SQL Managed Instance is to ensure that your database is up and running for at least 99.99 percent of the time, regardless of maintenance or outages.<\/p>\n\n\n\n<p>The high availability solution ensures that:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>data is never lost due to failures<\/li><li>maintenance activities do not disrupt your workload<\/li><li>database is not a single point of failure in your software architecture. There should be no downtimes or maintenance periods that force you to stop working while the database updates or maintains.<\/li><\/ul>\n\n\n\n<p>There are two high availability architectural models:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Standard availability model<\/strong>&nbsp;that is based on a separation of compute and storage. It relies on high availability and reliability of the remote storage tier. This architecture targets budget-oriented business applications that can tolerate some performance degradation during maintenance activities.<\/li><li><strong>Premium availability model<\/strong>&nbsp;that is based on a cluster of database engine processes. It relies on the fact that there is always a quorum of available database engine nodes. This architecture targets mission critical applications with high IO performance, high transaction rate and guarantees minimal performance impact to your workload during maintenance activities.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"basic-standard-and-general-purpose-service-tier-availability\"><strong>Basic, Standard, and General Purpose service tier availability<\/strong><\/h3>\n\n\n\n<p>For both serverless and provided computing, the Basic, Standard, and General Purpose service tiers use the standard availability architecture. The diagram below depicts four distinct nodes with computing and storage layers that are separated.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/media\/high-availability-sla\/general-purpose-service-tier.png\" alt=\"Separation of compute and storage\"\/><figcaption>Image Source &#8211; Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<p>The standard availability model includes two layers:<\/p>\n\n\n\n<p>A stateless compute layer that executes the sqlservr.exe process and only holds temporary and cached data and a stateful data layer that stores database files (.mdf\/.ldf) on Azure Blob storage.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"premium-and-business-critical-service-tier-availability\"><strong>Premium and Business Critical service tier availability<\/strong><\/h3>\n\n\n\n<p>The Premium and Business Critical service tiers use the Premium availability model, which combines computation (sqlservr.exe process) and storage (locally connected SSD) on one node. High availability is accomplished by duplicating computing and storage over many nodes, resulting in a three to four-node cluster.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/media\/high-availability-sla\/business-critical-service-tier.png\" alt=\"Cluster of database engine nodes\"\/><figcaption>Image Source &#8211; Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"hyperscale-service-tier-availability\"><strong>Hyperscale service tier availability<\/strong><\/h3>\n\n\n\n<p>The Hyperscale service tier architecture in\u00a0the Distributed functions architecture\u00a0is only currently available for SQL Database, not SQL Managed Instance.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/media\/high-availability-sla\/hyperscale-architecture.png\" alt=\"Hyperscale functional architecture\"\/><figcaption>Image Source &#8211; Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<p>The availability model in Hyperscale includes four layers:<\/p>\n\n\n\n<p>A stateless compute layer, A stateless storage layer formed by page servers, A stateful transaction log storage layer and A stateful data storage layer with the database files.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"zone-redundant-configuration\"><strong>Zone redundant configuration<\/strong><\/h3>\n\n\n\n<p>The premium availability model&#8217;s cluster of nodes is formed in the same datacenter by default. SQL Database may now deploy separate copies of the Business Critical database to different availability zones within the same area thanks to the advent of Azure Availability Zones. The control ring duplicates across many zones as three gateway rings to eliminate a single point of failure (GW).<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/media\/high-availability-sla\/zone-redundant-business-critical-service-tier.png\" alt=\"high availability architecture zone redundant\" width=\"409\" height=\"465\"\/><figcaption>Image Source &#8211; Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"accelerated-database-recovery-adr\"><strong>Accelerated Database Recovery (ADR)<\/strong><\/h3>\n\n\n\n<p>ADR (Accelerated Database Recovery) is a new database engine feature that dramatically increases database availability, particularly when long-running transactions are present. Azure SQL Database, Azure SQL Managed Instance, and Azure SQL Data Warehouse currently support ADR.<\/p>\n\n\n\n<p>Testing application fault resiliency &#8211;  High availability is a fundamental part of the SQL Database and SQL Managed Instance platform that works transparently for your database application.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.testpreptraining.ai\/microsoft-azure-architect-technologies-az-303-free-practice-test\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Untitled-design-5.png\" alt=\"free practice test for AZ- 303\" class=\"wp-image-13928\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Untitled-design-5.png 960w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Untitled-design-5-750x117.png 750w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><\/figure><\/div>\n\n\n\n<p><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-az-303-microsoft-azure-architect-technologies\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Go back to home page <\/strong><\/a><\/p>\n\n\n\n<p class=\"has-text-align-right\"><strong>Reference documentation &#8211; <\/strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/high-availability-sla\" target=\"_blank\" rel=\"noreferrer noopener\">High availability for Azure SQL Database and SQL Managed Instance<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial will help you know about the High availability for Azure SQL Database. The purpose of the high availability design in Azure SQL Database and SQL Managed Instance is to ensure that your database is up and running for at least 99.99 percent of the time, regardless of maintenance or outages. The high availability&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-15859","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>High availability for Azure SQL Database - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Enhance and upgrade your Azure Architect skills by preparing from the tutorial -High availability for Azure SQL Database. Crack the exam now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"High availability for Azure SQL Database - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Enhance and upgrade your Azure Architect skills by preparing from the tutorial -High availability for Azure SQL Database. Crack the exam now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-21T11:10:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/media\/high-availability-sla\/general-purpose-service-tier.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/\",\"name\":\"High availability for Azure SQL Database - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-08-08T05:27:30+00:00\",\"dateModified\":\"2022-03-21T11:10:21+00:00\",\"description\":\"Enhance and upgrade your Azure Architect skills by preparing from the tutorial -High availability for Azure SQL Database. Crack the exam now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"High availability for Azure SQL Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"High availability for Azure SQL Database - Testprep Training Tutorials","description":"Enhance and upgrade your Azure Architect skills by preparing from the tutorial -High availability for Azure SQL Database. Crack the exam now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/","og_locale":"en_US","og_type":"article","og_title":"High availability for Azure SQL Database - Testprep Training Tutorials","og_description":"Enhance and upgrade your Azure Architect skills by preparing from the tutorial -High availability for Azure SQL Database. Crack the exam now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2022-03-21T11:10:21+00:00","og_image":[{"url":"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/media\/high-availability-sla\/general-purpose-service-tier.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/","name":"High availability for Azure SQL Database - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-08-08T05:27:30+00:00","dateModified":"2022-03-21T11:10:21+00:00","description":"Enhance and upgrade your Azure Architect skills by preparing from the tutorial -High availability for Azure SQL Database. Crack the exam now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/high-availability-for-azure-sql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"High availability for Azure SQL Database"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/15859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=15859"}],"version-history":[{"count":5,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/15859\/revisions"}],"predecessor-version":[{"id":53262,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/15859\/revisions\/53262"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=15859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=15859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=15859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}