Improving Columnstore Load Scalability on Large Servers

YouTube·PASS Data Community Summit

Explore advanced techniques for optimizing clustered columnstore index load times in this comprehensive conference talk from PASS Data Community Summit. Dive into a detailed examination of columnstore scalability, following a journey that reduces total load time from 260 minutes to just 6 minutes. Learn production-tested methods derived from workloads handling billions of rows, applicable to SQL Server 2016, 2017, and 2019. Gain insights to enhance columnstore load performance, boost scalability on large servers, and tackle complex data warehouse challenges. Prerequisite knowledge includes a strong understanding of columnstore, wait stat analysis, extended events, and latches to fully benefit from this advanced session.