Chris has been using SQL Server for over fifteen years, his main area of expertise is pushing the database engine to its limits and making it scale. Currently Chris works at Pure Storage as the EMEA SQL Server solutions architect.
Column Store Index and Batch Mode Scalability Deep Dive
A deep dive into batch mode scalability with column store index and SQL 2014.
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.