Yes, there are limits to how much a single node can handle. There are only so many slots for physical disks, and physical disk volumes have limits. Is it possible to put 24 TB into a single node? Yes… (View Post)

select get_node_dependencies('1110') will show you the projections that are aligned in that way. There are 4 of them. Looks like you have some projections that were built as Ksafe=2. You ca… (View Post)

ExecutionParallelism is a pretty edge-case tuning knob. It's just as likely to hurt a query as help it, and even then, you're not likely to see significant differences in performance one wa… (View Post)

We're probably over-thinking this. ExecutionParallelism defaults to the # of cores. It is the maximum number of parallel threads that a query can use while executing. Setting it lower can restri… (View Post)

Wow, 128 cores is a lot! The MaxConcurrency value caps the number of queries in that pool. It has nothing to do with cores. Resource pools provide a way of prioritizing tasks by type, or restricting … (View Post)