Menu

1 / 2

Verifying That a GBase 8a Resource Plan Is Active and Enforcing Limits

DEV Community·Michael·6 months ago
#vKN7mbqH
#gbase#database#monitoring#software#pool
Reading 0:00
15s threshold

After activating a resource plan on a virtual cluster, a few quick checks will confirm it's working as expected and restricting CPU, memory, and concurrency for the target users in a gbase database .

1. Confirm the Plan Is Active

SELECT * FROM gbase . resource_config ;

Enter fullscreen mode

Exit fullscreen mode

The activated_plan column for the target VC should show the plan name you just activated (e.g., plan_day ).

2. Check User – Consumer Group Mapping

SELECT * FROM gbase . consumer_group_user ;

Enter fullscreen mode

Exit fullscreen mode

The target user (e.g., UserLoad ) must belong to the expected consumer group (e.g., group_load ).

3. Check Group – Resource Pool Binding

SELECT * FROM gbase . resource_plan_directive WHERE plan_name = 'plan_day' ;

Enter fullscreen mode

Exit fullscreen mode

You should see a directive that maps the consumer group to the correct resource pool (e.g., low_pool ).

4.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.