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

Share this: Twitter

Facebook

LinkedIn

Email

Like this: Like Loading... Related