Implementing Real-Time Operational Analytics in Azure SQL Database
1 h 10 m
In this lab, you will explore real-time operational analytics using Azure SQL Database. You will evaluate the performance improvements you will get when you add updateable non-clustered columnstore indexes on top of standard tables as well as memory-optimized tables.
- Implement Real-Time Operational Analytics in Azure SQL Database
- Understand the use cases for In-Memory Analytics in Azure SQL Database
- Previous experience with SQL Server or Azure SQL Database
In this exercise, you will create non-clustered columnstore indexes to improve performance of an analytic workload against an OLTP table. This is also known as Hybrid transactional/analytical processing (HTAP).
In this exercise, you will create non-clustered columnstore indexes on top of memory-optimized tables.