startup (latency) |
interference (communication, locking) |
load balance (execution skew - all the execution occurs in one partition) |
data-partition (data skew - all the data is placed in one partition) |
imbalance of system resources (CPUs and I/O channels) |
CPU-intensive or I/O intensive queries |