mountainss Cloud and Datacenter Management Blog

Microsoft SystemCenter blogsite about virtualization on-premises and Cloud

#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.

sql2016

Here you find SQL 2016 Hybrid Hyperscale  Architecture and implementation guidance 

Advertisements

Author: James van den Berg

I'm Microsoft Architect and ICT Specialist and Microsoft MVP System Center Cloud and Datacenter Management

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s