International Business Machines Corporation

Pathan Niyazulla Khan

Sweta Singh

Manish Anand

A method, computer program product, and system 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.

Root cause analysis of performance problems

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.

Growing community of inventors

Bengaluru, India

Pathan Niyazulla Khan