US 2024/0193006 A1 · MONITORING OF RESOURCE CONSUMPTION PER TENANT

Abstract

Systems and methods include reception, at a database instance hosting a plurality of database tenants, of a statement for execution in a first database session associated with a first tenant, determination of first tenant-level resource limits associated with the database session, determination, for one or more resources, of a total amount consumed by the first database session, determination, based on the first tenant-level resource limits and the total amount of the one or more resources consumed by the first database session, of whether the statement can be executed by the database instance in compliance with the first tenant-level resource limits, and execution of the statement if it is determined that the statement can be executed by the database instance in compliance with the first tenant-level resource limits.

Claims18

Dependent claims

A computer-implemented method comprising:

receiving, at a database instance hosting a plurality of database tenants, a statement for execution in a first database session associated with a first tenant;
determining first tenant-level resource limits associated with the database session;
determining, for one or more resources, a total amount consumed by the first database session;
determining, based on the first tenant-level resource limits and the total amount of the one or more resources consumed by the first database session, whether the statement can be executed by the database instance in compliance with the first tenant-level resource limits;
and
if it is determined that the statement can be executed by the database instance in compliance with the first tenant-level resource limits, executing the statement.

3 more elements

A system comprising:

a memory storing executable program code;
and
a processing unit to execute the program code to cause the system to:
receive, at a database instance hosting a plurality of database tenants, a statement for execution in a first database session associated with a first tenant;
determine first tenant-level resource limits associated with the first database session;
determine a total amount of one or more resources consumed by the first database session;
determine, based on the first tenant-level resource limits and the total amount of the one or more resources consumed by the first database session, whether the statement can be executed by the database instance in compliance with the first tenant-level resource limits;
and
execute the statement only if it is determined that the statement can be executed by the database instance in compliance with the first tenant-level resource limits.

6 more elements

A computer-readable medium storing program code executable by a computing system to cause the computing system to:

receive, at a database instance hosting a plurality of database tenants, a statement for execution in a first database session associated with a first tenant;
determine first tenant-level resource limits associated with the first database session;
determine a total amount of one or more resources consumed by the first database session;
determine, based on the first tenant-level resource limits and the total amount of the one or more resources consumed by the first database session, whether the statement can be executed by the database instance in compliance with the first tenant-level resource limits;
and
execute the statement only if it is determined that the statement can be executed by the database instance in compliance with the first tenant-level resource limits.

3 more elements

Dependencies are inferred from the claim text.

Monitoring of resource consumption per tenant

Life of this patent

Monitoring of resource consumption per tenant

Life of this patent

Abstract

Claims18