I'm building a Columnstore index right now. The output from
This is a dev machine. Nothing else is running. The server has 8GB of memory available to it. The CPU is nearly idle. The build seems to be in the global dictionary sampling phase because
sqlservr.exe is doing random disk IO and writing almost nothing.
SLEEP_TASK indicate that I can take action to make the index build go faster? Why is the build "sleeping" sometimes?
This is SQL Server 2014 SP1.