Level: Intermediate to Advanced
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