Real-time database performance and availability monitoring method and system

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.

1 .- 29 . (canceled) 
     
     
         30 . A machine-accessible storage medium having computer-executable instructions that, upon execution by a processor, cause the processor to perform operations 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.   
     
     
         31 . The medium of  claim 30 , including further instructions that cause the operations to further comprise:
 displaying a plurality of graphical representations corresponding to a plurality of database performance statistics obtained from at least one of the group consisting of: multiple databases, logical database clusters, and physical database clusters.   
     
     
         32 . The medium of  claim 30 , including further instructions that cause the operations to further comprise:
 displaying a plurality of graphical representations of a plurality of respective functions of at least one database performance statistic.   
     
     
         33 . The medium of  claim 31 , including further instructions that cause the operations to further comprise:
 displaying a plurality of graphical representations of a plurality of a respective functions of at least one of said plurality of database performance statistics.   
     
     
         34 . A machine-accessible storage medium having computer-executable instructions that, upon execution by a processor, cause the processor to perform operations 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.   
     
     
         35 . The medium of  claim 34 , containing further instructions that cause the operations to further comprise:
 changing a color of a cell of said table/grid when a current change in a value of a database performance statistic corresponding to said cell causes a monitoring alert condition to be triggered.   
     
     
         36 . The medium of  claim 34 , containing further instructions that cause the operations to further comprise:
 moving a row of said table/grid corresponding to a database that most recently triggered a monitoring alert to the top of the table/grid.   
     
     
         37 . The medium of  claim 34 , containing further instructions that cause the operations to further comprise:
 upon table cell selection by a pointing device, displaying a separate frame containing a graphical representation of the corresponding selected database performance statistic in a chart, said chart comprising a data set display area, a vertical database performance statistic value axis, and a horizontal axis of time.   
     
     
         38 . The medium of  claim 34 , containing further instructions that cause the operations to further comprise:
 upon table header selection by a pointing device, displaying a separate frame that contains a graphical representation of a corresponding selected database performance statistic across all databases in the table/grid in a single chart, said chart comprising a data set display area, a vertical database performance statistic value axis, and a horizontal axis of time.   
     
     
         39 . The medium of  claim 34 , containing further instructions that cause the operations to further comprise:
 upon database connection name selection by a pointing device, displaying a separate frame that contains a graphical representation of the database performance statistics related to the corresponding selected database as a single chart, said chart comprising a data set display area, a vertical database performance statistic value axis, and a horizontal axis of time.   
     
     
         40 .- 41 . (canceled) 
     
     
         42 . 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.   
     
     
         43 . The method of  claim 42 , further comprising:
 displaying a plurality of graphical representations corresponding to a plurality of database performance statistics obtained from at least one of the group consisting of: multiple databases, logical database clusters, and physical database clusters.   
     
     
         44 . The method of  claim 42 , further comprising:
 displaying a plurality of graphical representations of a plurality of respective functions of at least one database performance statistic.   
     
     
         45 . The method of  claim 43 , further comprising:
 displaying a plurality of graphical representations of a plurality of a respective functions of at least one of said plurality of database performance statistics.   
     
     
         46 . 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.   
     
     
         47 . The method of  claim 46 , further comprising:
 changing a color of a cell of said table/grid when a current change in a value of a database performance statistic corresponding to said cell causes a monitoring alert condition to be triggered.   
     
     
         48 . The method of  claim 46 , further comprising:
 moving a row of said table/grid corresponding to a database that most recently triggered a monitoring alert to the top of the table/grid.   
     
     
         49 . The method of  claim 46 , further comprising:
 upon table cell selection by a pointing device, displaying a separate frame containing a graphical representation of the corresponding selected database performance statistic in a chart, said chart comprising a data set display area, a vertical database performance statistic value axis, and a horizontal axis of time.   
     
     
         50 . The method of  claim 46 , further comprising:
 upon table header selection by a pointing device, displaying a separate frame that contains a graphical representation of a corresponding selected database performance statistic across all databases in the table/grid in a single chart, said chart comprising a data set display area, a vertical database performance statistic value axis, and a horizontal axis of time.   
     
     
         51 . The method of  claim 46 , further comprising:
 upon database connection name selection by a pointing device, displaying a separate frame that contains a graphical representation of the database performance statistics related to the corresponding selected database as a single chart, said chart comprising a data set display area, a vertical database performance statistic value axis, and a horizontal axis of time.