Real-time database performance and availability monitoring 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 database performance analysis comprising:
- setting a value of a time window size TP, where TP is a time period between a current moment of time t and a moment of time TP periods ago, t−
TP+1;
obtaining a value of a database performance statistic in the current moment of time t as VAL(t);
obtaining a highest value of the database performance statistic within a time period from t−
TP+1 to t, as HV(t);
obtaining a lowest value of the database performance statistic within the time period from t−
TP+1 to t, as LV(t);
calculating a normalized value of a data point at time t as (VAL(t)−
LV (t) )/(HV(t)−
LV(t) ).
2 Assignments
0 Petitions
Accused Products
Abstract
Database performance and availability monitoring of changes impacting database performance, availability and continuity to the underlying business may be performed. A method for doing so may include analytical and visual real-time analysis engines to identify and provide alert notifications on changes in database performance statistics (such as CPU consumption, physical I/O, etc.) related to a sample period of time on a single database or across multiple databases. Result data may be displayed through a series of charts and/or summary tables that may indicate whether correlations exist between unexpected database performance and relative changes in database performance statistical parameters.
-
Citations
41 Claims
-
1. A computer readable medium having computer-executable instructions that, when executed by a processor, cause the processor to perform a method of database performance analysis comprising:
-
setting a value of a time window size TP, where TP is a time period between a current moment of time t and a moment of time TP periods ago, t−
TP+1;
obtaining a value of a database performance statistic in the current moment of time t as VAL(t);
obtaining a highest value of the database performance statistic within a time period from t−
TP+1 to t, as HV(t);
obtaining a lowest value of the database performance statistic within the time period from t−
TP+1 to t, as LV(t);
calculating a normalized value of a data point at time t as (VAL(t)−
LV (t) )/(HV(t)−
LV(t) ). - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)
-
-
27. A computer readable medium having computer-executable instructions that, when executed by a processor, cause the processor to perform a method of obtaining descriptive metadata about database agent monitoring configuration, the method comprising:
-
calling at least one configuration self-descriptive function of the database monitoring agent from external application, wherein an output of said self-descriptive function comprises a list of metadata elements. - View Dependent Claims (28, 29)
-
-
30. A computer readable medium having computer-executable instructions that, when executed by a processor, cause the processor to perform a method comprising:
-
displaying a plurality of graphical representations of a plurality of respective database performance statistics related to a common database on a same chart, wherein the database performance statistics to be displayed are selected by a user;
said chart comprising a data set display area, a vertical database performance statistic value axis, and a horizontal axis of time; and
adding a new data point to the display upon receiving each new database performance statistic data point. - View Dependent Claims (31, 32, 33)
-
-
34. A computer readable medium having computer-executable instructions that, when executed by a processor, cause the processor to perform a method comprising:
-
displaying a plurality of textual representations of a plurality of database performance statistic values related to multiple databases in a form of table/grid within a frame, where at least one row of said table/grid represents multiple database performance statistics related to a single database and a first cell of said at least one row represents a database connection name, wherein every other cell of said at least one row represents a value selected from the group consisting of;
a value of a single database performance statistic and a value of a function of at least one database performance statistic;
said table/grid further including a header to display names of the database performance statistics; and
changing a value in at least one cell of the table/grid upon receiving new data corresponding to at least one database performance statistic. - View Dependent Claims (35, 36, 37, 38, 39)
-
-
40. A computer readable medium having computer-executable instructions that, when executed by a processor, cause the processor to perform a method of database performance analysis comprising:
-
calculating a database performance statistic moving average based on a database performance statistic using a database performance statistic moving average period, wherein said database performance statistic moving average period is one of the group consisting of;
a user-defined period and a predetermined default period; and
comparing a value of the database performance statistic with the value of the moving average to identify a percent difference between the value of the database performance statistic and the value of the moving average;
wherein said database performance statistic is selected from the group consisting of;
a direct database performance statistic and a derived database performance statistic.
-
-
41. A computer readable medium having computer-executable instructions that, when executed by a processor, cause the processor to perform a method of database performance analysis comprising:
-
comparing a current value of a database performance statistic with a previous value of the same database performance statistic obtained during a previous monitoring period to identify a percent difference between said current value and said previous value;
wherein said database performance statistic is selected from the group consisting of;
a direct database performance statistic and a derived database performance statistic.
-
Specification