DROP WLM RESOURCE POOL ​

Drop a workload management (WLM) resource pool.

DROP WLM RESOURCE POOL [ IF EXISTS ] name

Only superusers and users who have been granted CONTROL WLM ON SYSTEM can create, alter, and drop WLM resource pools. When you drop a WLM profile, its associated resource pools and rules are dropped.

IF EXISTS

Do not return a warning if the resource pool does not exist.

name

The pool name must match the name of an existing resource pool in the database.

For example:

premdb=# drop wlm resource pool longest_pool;
DROP WLM RESOURCE POOL

Query the sys.wlm_active_pool view to see the current pools in the system.

Note: The default and admin resource pools cannot be dropped.

Parent topic:SQL Commands