#### Create RESOURCE PLAN testrp;
```
create RESOURCE PLAN testrp;
CREATE POOL testrp.default.c1 WITH ALLOC_FRACTION=0.3, QUERY_PARALLELISM=3, SCHEDULING_POLICY='fair';
CREATE POOL testrp.default.c2 WITH ALLOC_FRACTION=0.5, QUERY_PARALLELISM=1, SCHEDULING_POLICY='fair';
SELECT * FROM SYS.WM_POOLS;
ALTER RESOURCE PLAN testrp VALIDATE;
ALTER RESOURCE PLAN testrp ENABLE ACTIVATE;
```


#### This will fail with error - Sum of children pools' alloc fraction should be less than 1 got: 1.0 for pool: default
```
create RESOURCE PLAN testrp1;
CREATE POOL testrp1.default.c1 WITH ALLOC_FRACTION=0.3, QUERY_PARALLELISM=3, SCHEDULING_POLICY='fair';
CREATE POOL testrp1.default.c2 WITH ALLOC_FRACTION=0.7, QUERY_PARALLELISM=1, SCHEDULING_POLICY='fair';
SELECT * FROM SYS.WM_POOLS;
ALTER RESOURCE PLAN testrp1 VALIDATE;
ALTER RESOURCE PLAN testrp1 ENABLE ACTIVATE;
```

#### This will SUCCEEDED
```
create RESOURCE PLAN testrp2;
CREATE POOL testrp2.default.c1 WITH ALLOC_FRACTION=0.3, QUERY_PARALLELISM=3, SCHEDULING_POLICY='fair';
CREATE POOL testrp2.default.c2 WITH ALLOC_FRACTION=0.6, QUERY_PARALLELISM=2, SCHEDULING_POLICY='fair';
SELECT * FROM SYS.WM_POOLS;
ALTER RESOURCE PLAN testrp2 VALIDATE;
ALTER RESOURCE PLAN testrp2 ENABLE ACTIVATE;
```

#### Disable resource plan
```
ALTER RESOURCE PLAN testrp2 DISABLE;
```
#### Disable workload management
```
DISABLE WORKLOAD MANAGEMENT
```
#### Show Resource Plan
```
SHOW RESOURCE PLANS;
SELECT * FROM SYS.WM_RESOURCEPLANS;
```

### Show pools
```
SELECT * FROM SYS.WM_POOLS;
```

### Alter pools
```
ALTER POOL plan_2.default.c2 SET SCHEDULING_POLICY='fair';
ALTER POOL plan_2.default.c2 UNSET SCHEDULING_POLICY;
ALTER POOL plan_2.default SET path = def;
SELECT * FROM SYS.WM_POOLS;


ALTER POOL testrp2.default SET  QUERY_PARALLELISM = 2;
ALTER POOL testrp2.default.c1 SET  QUERY_PARALLELISM = 1;
ALTER POOL testrp2.default.c2 SET  QUERY_PARALLELISM = 1;

DROP POOL plan_2.default;
SELECT * FROM SYS.WM_POOLS;


```

#### Create Trigger
```CREATE TRIGGER testrp2.trigger_1 WHEN ELAPSED_TIME > 300 DO KILL```

#### ADD trigger to the pool
```ALTER POOL testrp2.default ADD TRIGGER trigger_1```

#### Drop Trigger
```DROP TRIGGER plan_1.trigger_1;```


#### Show Triggers on pool
```SELECT * FROM SYS.WM_POOLS_TO_TRIGGERS;```