Monitoring of resource consumption per tenant

Patent metadata

Field	Value
Publication number	US-12498973-B2
Application number	US-202218063451-A
Country	US
Kind code	B2
Filing date	Dec 8, 2022
Priority date	Dec 8, 2022
Publication date	Dec 16, 2025
Grant date	Dec 16, 2025

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.

First claim

What is claimed is:

1 . 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 and first statement-level resource limits associated with the first tenant; determining, for each of one or more resources, a total amount previously consumed by the first database session; determining, for each of the one or more resources, an amount expected to be consumed by execution of the statement; determining that a sum of the total amount of the one or more resources previously consumed by the first database session and the amount expected to be consumed by execution of the statement is less than the first tenant-level resource limits and that the amount expected to be consumed by execution of the statement is less than the first statement-level resource limits; and in response to determining that the sum of the total amount of the one or more resources previously consumed by the first database session and the amount expected to be consumed by execution of the statement is less than the first tenant-level resource limits and that the amount expected to be consumed by execution of the statement is less than the first statement-level resource limits, executing the statement.

2 . A method according to claim 1 , further comprising:
pausing until it is determined that the sum of the total amount of the one or more resources previously consumed by the first database session and the amount expected to be consumed by execution of the statement is less than the first tenant-level resource limits and that the amount expected to be consumed by execution of the statement is less than the first statement-level resource limits.

3 . A method according to claim 2 , wherein the first tenant-level resource limits comprise a statement concurrency limit.

4 . A method according to claim 1 , further comprising:
receiving, at the database instance hosting a plurality of database tenants, a second statement for execution in a second database session associated with a second tenant; determining second tenant-level resource limits and second statement-level resource limits associated with the second tenant, the second tenant-level resource limits different from the first tenant-level resource limits and the second statement-level resource limits different from the first statement-level resource limits; determining, for the each of the one or more resources, a second total amount previously consumed by the second database session; determining, for each of the one or more resources, a second amount expected to be consumed by execution of the second statement; determining that a second sum of the second total amount of the one or more resources previously consumed by the second database session and the second amount expected to be consumed by execution of the second statement is less than the second tenant-level resource limits and that the second amount expected to be consumed by execution of the second statement is less than the second statement-level resource limits; and in response to determining that the second sum of the second total amount of the one or more resources previously consumed by the second database session and the second amount expected to be consumed by execution of the second statement is less than the second tenant-level resource limits and that the second amount expected to be consumed by execution of the second statement is less than the second statement-level resource limits, executing the second statement.

5 . 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 and first statement-level resource limits associated with the first tenant; determine a total amount of one or more resources previously consumed by the first database session; determine an amount of the one or more resources expected to be consumed by execution of the statement; determine that a sum of the total amount of the one or more resources previously consumed by the first database session and the amount expected to be consumed by execution of the statement is less than the first tenant-level resource limits and that the amount expected to be consumed by execution of the statement is less than the first statement-level resource limits; and execute the statement in response to the determination that the sum of the total amount of the one or more resources previously consumed by the first database session and the amount expected to be consumed by execution of the statement is less than the first tenant-level resource limits and that the amount expected to be consumed by execution of the statement is less than the first statement-level resource limits.

6 . A system according to claim 5 , the processing unit to execute the program code to cause the system to:
pause execution of the statement until it is determined that the sum of the total amount of the one or more resources previously consumed by the first database session and the amount expected to be consumed by execution of the statement is less than the first tenant-level resource limits and that the amount expected to be consumed by execution of the statement is less than the first statement-level resource limits.

7 . A system according to claim 6 , wherein the first tenant-level resource limits comprise a statement concurrency limit.

8 . A system according to claim 5 , the processing unit to execute the program code to cause the system to:
receive, at the database instance hosting the plurality of database tenants, a second statement for execution in a second database session associated with a second tenant; determine second tenant-level resource limits and second statement-level resource limits associated with the second tenant, the second tenant-level resource limits different from the first tenant-level resource limits and the second statement-level resource limits different from the first statement-level resource limits; determine a second total amount of each of the one or more resources consumed by the second database session; determine a second amount of the one or more resources expected to be consumed by execution of the second statement; determine that a second sum of the second total amount of the one or more resources previously consumed by the second database session and the second amount expected to be consumed by execution of the second statement is less than the second tenant-level resource limits and that the second amount expected to be consumed by execution of the second statement is less than the second statement-level resource limits; and execute the second statement in response to the determination that the second sum of the second total amount of the one or more resources previously consumed by the second database session and the second amount expected to be consumed by execution of the second statement is less than the second tenant-level resource limits and that the second amount expected to be consumed by execution of the second statement is less than the second statement-level resource limits.

9 . A non-transitory 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; determi

Assignees

• Sap Se

Inventors

• Joy Robin
• Karl Ruediger
• May Norman
• Scheuer Tobias
• Voelker Patrick
• Choi Jaeyoung
• Jung Hyogi

Classifications

• G06F11/3051 Primary

  Monitoring arrangements for monitoring the configuration of the computing system or of the computing system component, e.g. monitoring the presence of processing resources, peripherals, I/O links, software programs (verification or detection of system hardware configuration G06F11/2247) · CPC title

• G06F9/50

  Allocation of resources, e.g. of the central processing unit [CPU] · CPC title

• G06F2209/5016

  Session · CPC title

• G06F2209/5011

  Pool · CPC title

• G06F9/5077

  Logical partitioning of resources; Management or configuration of virtualized resources (specific details on emulation or internal functioning of virtual machines G06F9/455) · CPC title