×

Root cause analysis of performance problems

  • US 10,552,390 B2
  • Filed: 01/06/2017
  • Issued: 02/04/2020
  • Est. Priority Date: 01/06/2017
  • Status: Active Grant
First Claim
Patent Images

1. A method for identifying a computer performance bottleneck, wherein the computer performance bottleneck is a root cause and performance degradation during a root cause analysis (RCA) 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; and

    identifying a first set of target functions, associated with the correlation coefficient with the greatest value, based on the generated correlation matrix; and

    identifying the computer performance bottleneck based on the tabular representation of the target KPI.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×