Cloud and Datacenter Management Blog

Microsoft Hybrid Cloud blogsite about Management

#SQL 2016 Hybrid Hyperscale Architecture and implementation guidance #Azure

Leave a comment

SQL16 Hybrid Hyperscale

One of the major trends in the last few years has been a huge explosion in amount of data being generated by OLTP systems often coupled with the need to retain ever longer durations of historical data that needs to be made available for querying on demand. In order to meet customer needs in terms of data retention and performance, hosted database implementations had to choose between the following less than optimal options:

  • expanding and managing local storage which led to increasing cost
  • archive less frequently queried data into offline backup systems like tapes which prevents on-demand querying
  • simply put in place more aggressive data retention policies that reduced the need for this data to be stored in the first place leading to data loss

SQL Server 2016 introduces a number of major capabilities which enable seamless scale-out of SQL Server for low cost storage which is available for anytime On-Demand querying using Azure. With Azure’s almost limitless storage, hosters can offer low cost hyper-scale benefits to their SQL Server implementations for their customers. In this document, detailed technical guidance is provided in the context of a customer scenario on how to implement a hyper-scale database offering. For the implementation, the following SQL Server 2016 capabilities are leveraged

  • Stretched database and Azure Stretch database service
  • AlwaysOn Availability Groups with asynchronous replica in Azure
  • In-Memory ColumnStore
  • Temporal Database

The following Guide explains these capabilities and also enumerate considerations that the Hosting Service Provider (HSP) database administrator has to keep in mind while implementing this offer.


Here you find SQL 2016 Hybrid Hyperscale  Architecture and implementation guidance 

Author: James van den Berg

I'm Microsoft Architect and ICT Specialist and Microsoft MVP Cloud and Datacenter Management Microsoft MVP Windows Insider Microsoft Tech Community Insider Microsoft Azure Advisor

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.