Real-time Operational Analytics with the Intel® Xeon® Processor E5 Family and SQL Server* 2016

Real-time Operational Analytics with the Intel® Xeon® Processor E5 Family and SQL Server* 2016

Real-time Operational Analytics with the Intel® Xeon® Processor E5 Family and SQL Server* 2016

In this paper, we present SQL Server* 2016, which solves the problem by allowing customers to create a columnstore index on transactional data so that customers can run an online analytical processing (OLAP) query on the OLTP database in real time. This process is known as operational analytics, or hybrid transactional/analytical processing (HTAP). Operational analytics drastically cuts down time ...to meaningful insights, as there is no data latency associated with ETL or with creating and consequently updating a data warehouse. There is also a significant cost savings as you reduce the number of systems needed to produce real-time insights and to upgrade to high-performance Intel® Xeon® processor-based configurations that can transform data in record time. In addition, licensing costs also decrease as fewer processing stages are needed. Microsoft SQL Server 2016 can do this for disk-based tables as well as in-memory optimized tables.

Related Videos