SQL Server 2016 Operational Analytics

Play SQL Server 2016 Operational Analytics


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!



Download this episode

Download captions

The Discussion

  • User profile image
    Ekrem Onsoy

    Filtered Indexes are not there since SQL Server 2005 as opposed to what Sunil says, this feature has been added to the product since SQL Server 2008.

  • User profile image
    sunil agarwal

    Ekrem, the filtered index was done in SQL 2008, but it is available for columnstore (nonclustered index) only starting in SQL 2016

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.