Tune multi-tenant database performance
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
There are two multi-tenant governors which you can use to improve the performance of multi-tenant databases. These governors limit each tenant's access to the shared database resources. These multi-tenant governors are:
- Login Governor
- Lock Governor
The Login Governor (Tenant Max User Governor) specifies the maximum number
of users that may login for each tenant. The Lock Governor (Tenant Lock
Table Governor(%)) specifies the percentage of the lock table that
any tenant can occupy. The database startup parameter for Tenant
Max User Governor Login Governor is -nGovernor and
for Tenant Lock Table Governor(%) is -LGovernor.
When a tenant attempts to acquire more locks than the governor allows, an error message is displayed as: Attempt to exceed tenant lock governor for tenant <tenantID>. Increase -L or -LGovernor.
When a user attempts to login to a database and the available maximum number of logins for that tenant has been exceeded, an error message is displayed as: Attempt to exceed tenant login governor limit for tenant <tenant ID>. Increase -n or -nGovernor.
The Database Administration console and the PROMON utility help you to monitor and change the governor values for these parameters.
To monitor and change the values of these multi-tenant governors using the Database Configuration page, see Configure OpenEdge Components with OpenEdge Management.
To monitor and change the values of these multi-tenant governors using the PROMON utility, see Manage the OpenEdge Database.