US 12,079,189 B2
Automated database cache resizing
Ankit Khetarpal, San Jose, CA (US)
Assigned to ServiceNow, Inc., Santa Clara, CA (US)
Filed by ServiceNow, Inc., Santa Clara, CA (US)
Filed on Nov. 3, 2022, as Appl. No. 17/980,223.
Application 17/980,223 is a continuation of application No. 17/002,465, filed on Aug. 25, 2020, granted, now 11,520,767.
Prior Publication US 2023/0057160 A1, Feb. 23, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/22 (2019.01); G06F 9/30 (2018.01); G06F 11/34 (2006.01); G06F 16/21 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/2282 (2019.01) [G06F 9/30047 (2013.01); G06F 11/3419 (2013.01); G06F 16/214 (2019.01); G06F 16/24552 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
performing a test query of a database in response to determining that a performance associated with a user database query of the database does not satisfy a first performance threshold; and
in response to a determination that the performance of the test query satisfies a second performance threshold, resizing a database buffer cache of the database, wherein resizing the database buffer cache includes:
determining a metric based at least in part on a storage size of the database and an index size of the database; and
resizing the database buffer cache of the database based on the metric and a size of the database buffer cache.