ESTIMATING IMPACT OF CONFIGURATION CHANGES
First Claim
1. A method of estimating an impact of a software patch in a database environment, the method comprising:
- providing a production database in a production environment;
performing, with an enterprise application, a plurality of transactions to generate a production dataset in the production database;
recording, in the production database, the plurality of transactions with a database application testing program;
providing a first test database in a first test environment, the first test environment having a configuration similar to the production environment;
replaying the plurality of transactions in the first test database within the first test environment to produce a first test dataset;
measuring a first set of one or more performance indicators associated with replaying the plurality of transactions in the first test database, the first set of one or more performance indicators comprising at least one performance indicator other than structured query language (“
SQL”
) performance; and
providing a second test database in a modified test environment, the modified test environment having been modified from the first test environment by applying a software patch to at least one component of the first test environment;
replaying the plurality of transactions in the second test database within the modified test environment to produce a second test dataset;
measuring a second set of one or more performance indicators associated with replaying the plurality of transactions in the second test database, the second set of one or more performance indicators comprising at least one performance indicator other than SQL performance;
comparing one or performance indicators in the first set of performance indicators with one or more performance indicators in the second set of performance indicators;
estimating an impact of applying the software patch to the production environment based at least in part on replaying the plurality of transactions in the first test database and the second test database and on a comparison of one or more performance indicators in the first set of performance indicators with one or more performance indicators in the second set of performance indicators.
1 Assignment
0 Petitions
Accused Products
Abstract
Tools and techniques for providing an assessment of a prospective configuration change in a production database environment. In some cases, tools may record a series of transactions in a production database. This set of transactions can then be replayed by the tools in a test database, both before and after the configuration change has been performed. The performance of the workload in this test environment can be measured under both conditions (pre-change and post-change) to provide insight into a performance impact that might result from implementing the configuration change in the production environment.
155 Citations
24 Claims
-
1. A method of estimating an impact of a software patch in a database environment, the method comprising:
-
providing a production database in a production environment; performing, with an enterprise application, a plurality of transactions to generate a production dataset in the production database; recording, in the production database, the plurality of transactions with a database application testing program; providing a first test database in a first test environment, the first test environment having a configuration similar to the production environment; replaying the plurality of transactions in the first test database within the first test environment to produce a first test dataset; measuring a first set of one or more performance indicators associated with replaying the plurality of transactions in the first test database, the first set of one or more performance indicators comprising at least one performance indicator other than structured query language (“
SQL”
) performance; andproviding a second test database in a modified test environment, the modified test environment having been modified from the first test environment by applying a software patch to at least one component of the first test environment; replaying the plurality of transactions in the second test database within the modified test environment to produce a second test dataset; measuring a second set of one or more performance indicators associated with replaying the plurality of transactions in the second test database, the second set of one or more performance indicators comprising at least one performance indicator other than SQL performance; comparing one or performance indicators in the first set of performance indicators with one or more performance indicators in the second set of performance indicators; estimating an impact of applying the software patch to the production environment based at least in part on replaying the plurality of transactions in the first test database and the second test database and on a comparison of one or more performance indicators in the first set of performance indicators with one or more performance indicators in the second set of performance indicators.
-
-
2. A method of estimating an impact of a configuration change in a database environment, the method comprising:
-
recording, in a first database, a plurality of transactions; replaying the plurality of transactions in at least one test database; measuring at least one set of one or more performance indicators associated with replaying the plurality of transactions in the at least one test database, each set of one or more performance indicators comprising at least one performance indicator other than structured query language (“
SQL”
) performance;estimating an impact of a configuration change in a production database environment based at least in part on the at least one set of one or more performance indicators. - View Dependent Claims (3, 4)
-
-
5. A method of estimating an impact of a configuration change in a database environment, the method comprising:
-
recording, in a production database in a production environment, a plurality of transactions; providing a first test database in a first test environment; replaying the plurality of transactions in the first test database within the first test environment to produce a first test dataset; providing a second test database in a modified test environment; replaying the plurality of transactions in the second test database within the modified test environment to produce a second test dataset; and estimating an impact of a configuration change in the production environment based at least in part on replaying the plurality of transactions in the first test database and the second test database. - View Dependent Claims (6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22)
-
-
23. A computer system for measuring an impact of a configuration change in a database environment, the system comprising:
-
at least one processor; and a computer readable storage medium having encoded thereon a set of instructions executable by one or more of the at least one processor to perform one or more operations, the set of instructions comprising; instructions for recording, in a production database in a production environment, a plurality of transactions; instructions for replaying the plurality of transactions in the first test database within the first test environment to produce a first test dataset; instructions for replaying the plurality of transactions in the second test database within the modified test environment to produce a second test dataset; and instructions for estimating an impact of a configuration change in the production environment based at least in part on replaying the plurality of transactions in the first test database and the second test database.
-
-
24. An apparatus comprising:
a computer readable storage medium having encoded thereon a set of instructions executable by a computer system to perform one or more operations, the set of instructions comprising; instructions for recording, in a production database in a production environment, a plurality of transactions; instructions for replaying the plurality of transactions in the first test database within the first test environment to produce a first test dataset; instructions for replaying the plurality of transactions in the second test database within the modified test environment to produce a second test dataset; and instructions for estimating an impact of a configuration change in the production environment based at least in part on replaying the plurality of transactions in the first test database and the second test database.
Specification