Try OpenEdge Now
skip to main content
Configuring Multi-tenancy
Managing multi-tenant databases : Managing a multi-tenant database : Tuning multi-tenant database performance

Tuning multi-tenant database performance

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
Note: These governors are applicable to only the default tenant and regular tenant; these governors do not apply to a super-tenant. Also, these governors do not apply to non multi-tenant databases.
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 OpenEdge Management and OpenEdge Explorer: Configuration.
To monitor and change the values of these multi-tenant governors using the PROMON utility, see OpenEdge Data Management: Database Administration.