SQL Server Columnstore Performance Tuning

Download

Right click “Save as…”

Slides (view online)
Columnstore indexes, and a new, vector-based query execution method called “batch mode,” can speed up query processing in data warehouses and data marts using SQL Server 2012 by a breathtaking 10X to 100X. This talk describes how to tune indexes, queries, and load processes to help your customers get the most out of columnstore indexes and query execution. You’ll learn secrets that can help you turn modest performance gains into stunning, orders-of-magnitude improvements, and blow away the competition. We’ll focus on how to work around constraints that limit the use of batch processing when outer joins, unions, and certain other constructs are present in queries. We’ll also describe how to load columnstores effectively, and even perform real-time loads on columnstore indexes that are technically read-only. #TEDBI409
For more information, check out this course on Microsoft Virtual Academy:

Follow the Discussion

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.