Architects and DBAs
Imagine your Data Warehouse is growing exponentially to multi-terabytes and you have been tasked to make analytics queries even faster while keeping the cost of storage low. Industry leading SQL Server 2016 columnstore technology can help you solve these by reducing the storage footprint by 10x (average) and speed up analytics queries up to 100x. SQL Server Tiger team has leveraged columnstore technology with many Tier-1 workloads to achieve these goals. This session will cover three different types of workload. For each workload, we will cover the application architecture, challenges and how SQL Tiger team used columnstore index technology to address them.
Why I Want to Present This Session:
First, I want raise the awareness that the columnstore technology can manage large amount of data efficiently with significant speedup of analytics queries. Second, the columnstore technology has been successfully applied in workloads other than DW such as running analytics on transactional workload without the need to move the data for analytics to a dedicated DW.