Building a ColumnStore index hogs system resources I am experimenting with the columnstore and I am finding that while it is building the process hogs all the system resources. I have a table with 2.3 billion rows and while I build the columnstore on it all other queries come to a complete stand still. Is there a way to limit the amount of resources used by the columnstore build so that my other queries can continue to run. The other queries do not involve this table.
Run the index build in a resource governor group that limits the resources you want to give. Columnstore building is CPU and memory intensive. Resource governor should be your preferred way to throttle resources, no matter the scenario.