Reducing lock occurrences in server/database systems
First Claim
1. A computer-implemented method for limiting the number of concurrent requests in a database system comprising:
- defining a maximum value (SS) of concurrent requests corresponding to at least one queue;
monitoring at least one queue utilization parameter corresponding to the at least one queue and calculating a performance value (PF) based on the at least one queue utilization parameter, wherein the performance value (PF) is calculated for a first period of time (MP(act)−
Δ
MP), wherein the performance value (PF) of the first period of time (MP(act)−
Δ
MP) is used to adapt the maximum value (SS) of concurrent requests in a second period of time (MP(act)), which immediately follows after the first period of time (MP(act)−
Δ
MP);
adapting the maximum value (SS) of concurrent requests of the at least one queue dynamically based on the performance value (PF); and
limiting the number of concurrent requests of the at least one queue dynamically based on the dynamically adapted maximum value (SS).
1 Assignment
0 Petitions
Accused Products
Abstract
Limiting the number of concurrent requests in a database system. Arranging requests to be handled by the database system in at least one queue. Defining a maximum value (SS) of concurrent requests corresponding to the at least one queue. Monitoring at least one queue utilization parameter corresponding to the at least one queue and calculating a performance value based on the at least one queue utilization parameter. Adapting the maximum value (SS) of concurrent requests of the at least one queue dynamically based on the performance value (PF) in order to improve system performance. Limiting the number of concurrent requests of the at least one queue dynamically based on the dynamically adapted maximum value (SS).
41 Citations
15 Claims
-
1. A computer-implemented method for limiting the number of concurrent requests in a database system comprising:
-
defining a maximum value (SS) of concurrent requests corresponding to at least one queue; monitoring at least one queue utilization parameter corresponding to the at least one queue and calculating a performance value (PF) based on the at least one queue utilization parameter, wherein the performance value (PF) is calculated for a first period of time (MP(act)−
Δ
MP), wherein the performance value (PF) of the first period of time (MP(act)−
Δ
MP) is used to adapt the maximum value (SS) of concurrent requests in a second period of time (MP(act)), which immediately follows after the first period of time (MP(act)−
Δ
MP);adapting the maximum value (SS) of concurrent requests of the at least one queue dynamically based on the performance value (PF); and limiting the number of concurrent requests of the at least one queue dynamically based on the dynamically adapted maximum value (SS). - View Dependent Claims (2, 3, 4, 5)
-
-
6. A computer program product for limiting the number of concurrent requests in a database system, the computer program product comprising:
one or more computer-readable storage media and program instructions stored on the one or more computer-readable storage media, the program instructions comprising; program instructions to define a maximum value (SS) of concurrent requests corresponding to at least one queue; program instructions to monitor at least one queue utilization parameter corresponding to the at least one queue and calculating a performance value (PF) based on the at least one queue utilization parameter, wherein the performance value (PF) is calculated for a first period of time (MP(act)−
Δ
MP), wherein the performance value (PF) of the first period of time (MP(act)−
Δ
MP) is used to adapt the maximum value (SS) of concurrent requests in a second period of time (MP(act)), which immediately follows after the first period of time (MP(act)−
Δ
MP);program instructions to adapt the maximum value (SS) of concurrent requests of the at least one queue dynamically based on the performance value (PF); and program instructions to limit the number of concurrent requests of the at least one queue dynamically based on the dynamically adapted maximum value (SS). - View Dependent Claims (7, 8, 9, 10)
-
11. A computer system for limiting the number of concurrent requests in a database system, the computer system comprising:
one or more computer processors, one or more computer-readable storage media, and program instructions stored on the one or more computer-readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising; program instructions to define a maximum value (SS) of concurrent requests corresponding to at least one queue; program instructions to monitor at least one queue utilization parameter corresponding to the at least one queue and calculating a performance value (PF) based on the at least one queue utilization parameter, wherein the performance value (PF) is calculated for a first period of time (MP(act)−
Δ
MP), wherein the performance value (PF) of the first period of time (MP(act)−
Δ
MP) is used to adapt the maximum value (SS) of concurrent requests in a second period of time (MP(act)), which immediately follows after the first period of time (MP(act)−
Δ
MP);program instructions to adapt the maximum value (SS) of concurrent requests of the at least one queue dynamically based on the performance value (PF); and program instructions to limit the number of concurrent requests of the at least one queue dynamically based on the dynamically adapted maximum value (SS). - View Dependent Claims (12, 13, 14, 15)
Specification