Root cause analysis of performance problems
First Claim
1. A method for identifying a computer performance bottleneck by analyzing performance of a computer system based on key performance indicators (KPIs), the method comprising:
- at a plurality of time intervals, monitoring a set of KPIs of a database and database performance outputs, wherein a KPI is associated with execution of one or more functions;
calculating a database performance value based on the monitored KPIs and one or more database performance outputs;
in response to determining the database performance value is below a first threshold, calculating a KPI correlation coefficient representing a correlation between the set of KPIs and corresponding database performance values;
selecting the calculated KPI correlation coefficient with the greatest value as a target KPI;
in response to determining that a count of functions of the target KPI meets a second threshold, generating a dynamic tabular representation of the determined target KPI, wherein the columns represent KPIs and the rows represent functions;
generating a correlation matrix based on the generated tabular representation and the plurality of time intervals;
identifying a first set of target functions, where in the target functions are SQL functions associated with the correlation coefficient with the greatest value, based on the generated correlation matrix;
determine a time spent per function value for each target functions of the set of target functions;
in response to the determined time spent per function value being above a third threshold, generating a dynamic tabular representation of the target KPI, wherein the tabular representation includes columns and rows, wherein the columns represent one or more KPIs and the rows represent SQL functions;
communicating, via a display on a user device, the generated dynamic tabular representation of the target KPI to a user;
in response to receiving a user input selection via the user device, modifying the generated dynamic tabular representation of the target KPI, wherein modifying the generated dynamic tabular representation of the target KPI comprises applying a weight to the KPI correlation coefficient of the target KPI; and
identify a performance bottleneck based on the modified tabular representation of the target KPI and received user input.
1 Assignment
0 Petitions
Accused Products
Abstract
A method for analyzing performance of a computer system where at a plurality of time intervals, a set of KPIs of a database and database performance outputs are monitored. A database performance value is calculated based on the monitored KPIs and one or more database performance outputs. In response to determining the database performance value is below a first threshold, a KPI correlation coefficient is calculated. The calculated KPI correlation coefficient with the greatest value is selected as a target KPI. In response to determining that a count of functions of the target KPI meets a second threshold, a dynamic tabular representation of the determined target KPI is generated. A correlation matrix is generated based on the generated tabular representation and the plurality of time intervals and a first set of target functions are identified based on the generated correlation matrix.
14 Citations
1 Claim
-
1. A method for identifying a computer performance bottleneck by analyzing performance of a computer system based on key performance indicators (KPIs), the method comprising:
-
at a plurality of time intervals, monitoring a set of KPIs of a database and database performance outputs, wherein a KPI is associated with execution of one or more functions; calculating a database performance value based on the monitored KPIs and one or more database performance outputs; in response to determining the database performance value is below a first threshold, calculating a KPI correlation coefficient representing a correlation between the set of KPIs and corresponding database performance values; selecting the calculated KPI correlation coefficient with the greatest value as a target KPI; in response to determining that a count of functions of the target KPI meets a second threshold, generating a dynamic tabular representation of the determined target KPI, wherein the columns represent KPIs and the rows represent functions; generating a correlation matrix based on the generated tabular representation and the plurality of time intervals; identifying a first set of target functions, where in the target functions are SQL functions associated with the correlation coefficient with the greatest value, based on the generated correlation matrix; determine a time spent per function value for each target functions of the set of target functions; in response to the determined time spent per function value being above a third threshold, generating a dynamic tabular representation of the target KPI, wherein the tabular representation includes columns and rows, wherein the columns represent one or more KPIs and the rows represent SQL functions; communicating, via a display on a user device, the generated dynamic tabular representation of the target KPI to a user; in response to receiving a user input selection via the user device, modifying the generated dynamic tabular representation of the target KPI, wherein modifying the generated dynamic tabular representation of the target KPI comprises applying a weight to the KPI correlation coefficient of the target KPI; and identify a performance bottleneck based on the modified tabular representation of the target KPI and received user input.
-
Specification