Press "Enter" to skip to content

Columnstore and a Scheduler per Partition

Aaron Bertrand continues looking at columnstore indexing:

The idea is I would have eight instances of an application (SQLQueryStress) that would each run on a dedicated scheduler, handling only the data destined for a specific partition / filegroup / data file, ~100 million rows at a time

It was interesting seeing how to pull that off. Aaron also has some extended findings, so check it out.