| 发明名称 |
REDUCING LOCK OCCURRENCES IN SERVER/DATABASE SYSTEMS |
| 摘要 |
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). |
| 申请公布号 |
US2016070738(A1) |
申请公布日期 |
2016.03.10 |
| 申请号 |
US201514943057 |
申请日期 |
2015.11.17 |
| 申请人 |
International Business Machines Corporation |
发明人 |
Gocek Pawel;Lech Grzegorz K.;Malecki Bartlomiej T.;Marszalek Jan;Wawrzyczek Joanna |
| 分类号 |
G06F17/30;G06F9/52 |
主分类号 |
G06F17/30 |
| 代理机构 |
|
代理人 |
|
| 主权项 |
1. A computer-implemented method for limiting the number of concurrent requests in a database system, the computer-implemented method comprising:
defining a maximum value (SS) of concurrent requests corresponding to at least one queue, wherein the maximum value (SS) of concurrent requests is chosen to maximize the product of the number of concurrent requests and an average processing time of requests (APT); 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; 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; and limiting the number of concurrent requests of the at least one queue dynamically based on the dynamically adapted maximum value (SS). |
| 地址 |
Armonk NY US |
