{"id":30036,"date":"2020-03-26T09:00:09","date_gmt":"2020-03-26T16:00:09","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=30036"},"modified":"2024-01-22T22:51:25","modified_gmt":"2024-01-23T06:51:25","slug":"use-hyperscale-for-your-most-demanding-cloud-born-workloads","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/","title":{"rendered":"Use hyperscale for your most demanding cloud-born workloads"},"content":{"rendered":"<p>Sometimes resource demands increase beyond your expectations. Azure SQL Database service continues to meet your needs regardless of your speed of growth. The <a href=\"https:\/\/docs.microsoft.com\/azure\/sql-database\/sql-database-service-tier-hyperscale\" target=\"_blank\" rel=\"noopener noreferrer\">hyperscale service tier<\/a> for a single database enables you to scale to 100 TB with fast backup and restore capabilities. Learn about other options for running Microsoft SQL Server in Azure in the e-book <a href=\"http:\/\/aka.ms\/dbmseries_hyper_open\" target=\"_blank\" rel=\"noopener noreferrer\">Future-Proof Your Data Infrastructure with Azure: A Business Case for Database Administrators<\/a><em>.<\/em><\/p>\n<p>Each single database in <a href=\"https:\/\/docs.microsoft.com\/azure\/sql-database\/sql-database-technical-overview\" target=\"_blank\" rel=\"noopener noreferrer\">Azure SQL Database service<\/a> is guaranteed its own dedicated compute, memory, and storage resources that you can scale dynamically. If you need to scale out the storage and compute resources substantially beyond the limits for the general purpose and business critical service tiers, you\u2019re in luck. The hyperscale service tier provides highly scalable storage and compute performance that leverages the Azure architecture to meet the largest needs of an Azure SQL Database.<\/p>\n<h2>The benefits of hyperscale<\/h2>\n<p>With the hyperscale service tier, Microsoft removed many of the limits seen in other cloud databases. For example, most other databases are limited by the resources available in a single node. You don\u2019t have those limits in the hyperscale service tier. Hyperscale databases aren\u2019t created with a defined maximum size. A flexible storage architecture allows a hyperscale database to grow as needed. And you\u2019re only billed for the capacity you use.<\/p>\n<p>The hyperscale service tier also won&#8217;t box you into your initial configuration. Hyperscale databases can be backed up almost instantaneously\u2014regardless of the volume of data in the database. You can also scale a database in the tens of terabytes in minutes.<\/p>\n<h2>Do you need to go hyperscale?<\/h2>\n<p>The hyperscale service tier supports a broad range of SQL Server workloads, from pure online transactional processing (OLTP) to pure analytics. However, it\u2019s optimized for OLTP and hybrid transaction and analytical processing (HTAP) workloads. That said, hyperscale provides flexibility and high performance, two features that can benefit most business workloads. However, hyperscale will be particularly advantageous to you in the following scenarios:<\/p>\n<ul>\n<li>If you have a large on-premises database and want to modernize applications by moving them to the cloud.<\/li>\n<li>If you\u2019re running databases in Azure but are limited by the database size restrictions of the other service tiers.<\/li>\n<li>If you have smaller databases that require fast compute scaling, high performance, instant backup, and fast database restore.<\/li>\n<\/ul>\n<p>The hyperscale architectural model provides nearly instantaneous database backups with no impact on compute resources, the database restores in minutes rather than hours or days, and there is higher overall performance, and rapid scale-out and scale-up. Now there\u2019s no need to worry about how much or how fast your database will grow. The hyperscale service tier in Azure SQL Database has you covered.<\/p>\n<p>&nbsp;<\/p>\n<p>To learn more about moving SQL Server to the cloud, download <a href=\"http:\/\/aka.ms\/dbmseries_hyper_close\" target=\"_blank\" rel=\"noopener noreferrer\">Future-Proof Your Data Infrastructure with Azure: A Business Case for Database Administrators<\/a><em>.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes resource demands increase beyond your expectations. Azure SQL Database service continues to meet your needs regardless of your speed of growth. The hyperscale service tier for a single database enables you to scale to 100 TB with fast backup and restore capabilities. Learn about other options for running Microsoft SQL Server in Azure in<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5226,2391],"content-type":[2424],"topic":[2469],"coauthors":[2487],"class_list":["post-30036","post","type-post","status-publish","format-standard","hentry","product-azure","product-azure-sql-database","content-type-best-practices","topic-high-performance-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Use hyperscale for your most demanding cloud-born workloads - Microsoft SQL Server Blog<\/title>\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.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Use hyperscale for your most demanding cloud-born workloads - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Sometimes resource demands increase beyond your expectations. Azure SQL Database service continues to meet your needs regardless of your speed of growth. The hyperscale service tier for a single database enables you to scale to 100 TB with fast backup and restore capabilities. Learn about other options for running Microsoft SQL Server in Azure in\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-26T16:00:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Use hyperscale for your most demanding cloud-born workloads\",\"datePublished\":\"2020-03-26T16:00:09+00:00\",\"dateModified\":\"2024-01-23T06:51:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/\"},\"wordCount\":487,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/\",\"name\":\"Use hyperscale for your most demanding cloud-born workloads - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2020-03-26T16:00:09+00:00\",\"dateModified\":\"2024-01-23T06:51:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Use hyperscale for your most demanding cloud-born workloads\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Use hyperscale for your most demanding cloud-born workloads - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/","og_locale":"en_US","og_type":"article","og_title":"Use hyperscale for your most demanding cloud-born workloads - Microsoft SQL Server Blog","og_description":"Sometimes resource demands increase beyond your expectations. Azure SQL Database service continues to meet your needs regardless of your speed of growth. The hyperscale service tier for a single database enables you to scale to 100 TB with fast backup and restore capabilities. Learn about other options for running Microsoft SQL Server in Azure in","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2020-03-26T16:00:09+00:00","article_modified_time":"2024-01-23T06:51:25+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Use hyperscale for your most demanding cloud-born workloads","datePublished":"2020-03-26T16:00:09+00:00","dateModified":"2024-01-23T06:51:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/"},"wordCount":487,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/","name":"Use hyperscale for your most demanding cloud-born workloads - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2020-03-26T16:00:09+00:00","dateModified":"2024-01-23T06:51:25+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/26\/use-hyperscale-for-your-most-demanding-cloud-born-workloads\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Use hyperscale for your most demanding cloud-born workloads"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/30036"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=30036"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/30036\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=30036"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=30036"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=30036"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=30036"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=30036"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=30036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}