Automated database cache resizing
AssigneeServiceNow, Inc.
InventorAnkit Khetarpal
Life of this patent
Estimating the term…
Abstract
A determination is made that the performance of a user database query to a database does not meet a first performance threshold. In response to the user database query not meeting the first performance threshold, one or more test queries of the database are performed. A second determination is made whether a performance of the one or more test queries meets a second performance threshold. In response to the one or more test queries meeting the second performance threshold, an analysis is performed to determine whether to resize a database buffer cache of the database.
Claims20
A method, comprising:
- determining that a performance of a user database query to a database does not meet a first performance threshold;
- in response to the determination that the performance of the user database query to the database does not meet the first performance threshold, performing one or more test queries of the database;
- determining whether a performance of the one or more test queries meets a second performance threshold;
- and
- in response to the determination that the performance of the one or more test queries does meet the second performance threshold, performing an analysis to determine whether to resize a database buffer cache of the database.
A system, comprising:
- one or more processors;
- and
- a memory coupled to the one or more processors, wherein the memory is configured to provide the one or more processors with instructions which when executed cause the one or more processors to:
- determine that a performance of a user database query to a database does not meet a first performance threshold;
- in response to the determination that the performance of the user database query to the database does not meet the first performance threshold, perform one or more test queries of the database;
- determine whether a performance of the one or more test queries meets a second performance threshold;
- and
- in response to the determination that the performance of the one or more test queries does meet the second performance threshold, perform an analysis to determine whether to resize a database buffer cache of the database.
A method, comprising:
- determining that a performance of a user database query to a database does not meet a first performance threshold;
- in response to the determination that the performance of the user database query to the database does not meet the first performance threshold, performing a test query of the database;
- determining whether a performance of the test query does not meet a second performance threshold;
- in response to the determination that the performance of the test query does not meet the second performance threshold, determining whether the test query has successfully completed;
- and
- in response to the determination that the test query has not successfully completed, performing an analysis to determine whether to resize a database buffer cache of the database.
Dependencies are inferred from the claim text.