In this episode of Data Exposed, Scott Welcomes Sunil Agarwal, Principle Program Manager on the SQL Server team. Today, Sunil walks us through the operational analytics feature in SQL Server 2016. Operational Analytics is the ability to analyze the operations and transactions within your database. Sunil begins by giving us an overview of today’s operational and analytical landscape in SQL Server, and then explains how operational analytics can give us real-time insights into our data; ie., real-time analytics.
Sunil shows us how operational analytics minimizes impact on our OLTP systems by creating the ability to define hot and warm data via a clustered columnstore index with predicates. Sunil walks us through how this works, and architecture behind and what can expect from this exciting new feature!