Column Store Index and Batch Mode Scalability Deep Dive
This session will take a deep dive into query scalability with column store indexes and batch mode, this presentation will illustrate how by leveraging vectorised processing and CPU L2/3 cache batch mode scales and compare this to row mode. Stack walking will be used to quantify the cost of conventional page and row compression, column store versus the new to SQL 2014 column store archive compression and row mode versus batch mode operators. The affect of storage that can and cannot keep up with the available CPU resource will be covered along with how well batch mode scales across 24 schedulers.
Chris is a free lance devleoper / DBA with a passion for squeezing performance out OLTP applications which he has practised over a fifteen year career over a variety of sectors within IT.