Menu

Post image 1
Post image 2
1 / 2
0

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

DEV Community·Michael·18 days ago
#vKN7mbqH
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.

Read More