SQL Server 2017 Administrator's Guide

Example 3 – improving real-time analytics

The previous examples relied on the performance ensured by memory storage. But if data contention is actually huge, it's a good idea to improve the read load and at the same time not affect write load. In this example, we will just enhance the solution described in the previous section.

When we think of real-time analytics, we can imagine some kind of aggregation queries which are issued by a client frequently. As an example, we can use a regularly (and often) refreshed dashboard. Such dashboards or any other aggregate queries requested can often profit from columnstore indexes. SQL Server enables us to create columnstore indexes over an In-Memory structure. The sample script looks like this:

alter ...