BI, Big Data, Data Analytics, and Data Visualization

SQH12 Operational Analytics in SQL Server 2016

11/16/2017

2:30pm - 3:45pm

Level: Intermediate to Advanced

Edwin Sarmiento

Managing Director

15C

SQL Server 2016 introduces the ability to run both analytics and OLTP workloads on the same database tables at the same time with minimal impact on business critical OLTP workloads. This session covers how this is made possible with the new storage structures in the database engine, various configurations and best practices for achieving significant performance gains using SQL Server 2016 Operational Analytics.

You will learn:

  • The new storage structures in SQL Server 2016 that made Operational Analytics possible
  • Best practices in implementing SQL Server 2016 Operational Analytics
  • Index maintenance strategies when implementing SQL Server 2016 Operational Analytics