Real-time database performance and availability change root cause analysis method and system
First Claim
1. A computer readable medium having computer-executable instructions that, when executed by a processor, cause the processor to perform a method of root cause analysis of database system performance and availability issues, the method comprising:
- obtaining a value of each of one or more database-related quantities selected from the group consisting of database parameters and database performance statistics at a beginning point of time T(i);
obtaining a value of each of said one or more database-related quantities at an ending point of time T(i+1);
calculating and recording value differences between ending and starting values for each of said one or more database-related quantities and recording the duration between T(i) and T(i+1) and a current time stamp; and
enabling a user to view the difference for each of said one or more database-related quantities to determine at least one item selected from the group consisting of;
a greatest absolute value, a greatest percent increase, and an impact on performance of the database system.
2 Assignments
0 Petitions
Accused Products
Abstract
Root cause analysis of changes impacting database performance, availability and continuity to the underlying business may be performed. A system for doing so may include analytical and visual comparison root cause analysis engines to identify changed database performance statistical parameters (such as CPU consumption, physical I/O, etc) related to a historical period of time on a single database or across multiple databases. Result data may be displayed through a series of charts and reports that may indicate whether correlations exist between unexpected database performance and relative changes in database performance statistical parameters. A visual root cause analysis system may further apply noise reduction algorithms to clarify trends in changes of database system performance.
-
Citations
37 Claims
-
1. A computer readable medium having computer-executable instructions that, when executed by a processor, cause the processor to perform a method of root cause analysis of database system performance and availability issues, the method comprising:
-
obtaining a value of each of one or more database-related quantities selected from the group consisting of database parameters and database performance statistics at a beginning point of time T(i);
obtaining a value of each of said one or more database-related quantities at an ending point of time T(i+1);
calculating and recording value differences between ending and starting values for each of said one or more database-related quantities and recording the duration between T(i) and T(i+1) and a current time stamp; and
enabling a user to view the difference for each of said one or more database-related quantities to determine at least one item selected from the group consisting of;
a greatest absolute value, a greatest percent increase, and an impact on performance of the database system. - View Dependent Claims (29)
-
-
2. A computer readable medium having computer-executable instructions that, when executed by a processor, cause the processor to perform a method of root cause analysis of database system performance and availability issues, the method comprising:
-
obtaining value difference values of each of one or more database-related quantities selected from the group consisting of database parameters and database performance statistics at a beginning point of time T(i);
obtaining value difference values of each of said one or more database-related quantities at an ending point of time T(i+1);
obtaining a value of each of said one or more database-related quantities at another beginning point of time T(j);
obtaining a value of each of said one or more database-related quantities at another ending point of time T(j+1);
calculating and recording value differences between ending and starting values for each of said one or more database-related quantities and recording the duration between T(i) and T(i+1) and a current time stamp, said value differences collectively denoted VAL(i);
calculating and recording value differences between ending and starting values for each of said one or more database-related quantities for the starting time T(j) and the ending time T(j+1), and recording the duration between T(j) and T(j+1) and a current time stamp, said value differences collectively denoted VAL(j);
calculating and recording at least one value difference between VAL(j) and VAL(i); and
enabling a user to review the difference for each database-related quantity to determine at least one item selected from the group consisting of;
a relative value of increase or decrease; and
impact of a relative value of increase or decrease on performance of a database system between two performance collection periods. - View Dependent Claims (3, 4, 5, 6, 7, 8, 30)
-
-
9. A computer readable medium having computer-executable instructions that, when executed by a processor, cause the processor to perform a method of calculating and displaying single database performance statistic data on a single database comprising:
-
identifying sets of data points from a set of single database performance statistics for a single database, wherein each database performance data point is calculated and recorded as a difference between database performance statistic values of two adjacent data points in time T(i) and T(i+1) and wherein a corresponding timestamp value is recorded; and
displaying the data points on a chart, said chart comprising a data set display area, a vertical database performance statistic value axis, and a horizontal axis of time. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 31, 32, 33, 34, 35, 36, 37)
-
Specification