Resources influencing cluster performance include the memory, CPU, disk I/O, and storage space.
During service operation, system resources may not be fully utilized, and some nodes in a cluster or some resources in the system may become the cluster performance bottleneck. DWS provides resource management methods to balance system resource usage among tasks.
CPU and memory are computing resources of a server. Centralized control over them prevents resource conflicts of jobs, performs high-priority jobs (such as generating key reports) before others, and isolates user resources.
Storage space management is an important feature in the multi-tenant scenario. It limits the storage space quotas for users. DWS provides a simple syntax interface used for specifying the size of the storage space when you create a user, collecting statistics on and controlling the storage space based on internal logics.
As shown in Figure 1:
The resource pool is a basic unit of load management in DWS. It manages system resources (including CPU, I/O, and memory) required by service operations and controls SQL concurrency.