Apparatus and method for enabling a user to monitor skew of resource usage across different components of a large database system

摘要

A method and apparatus are provided for facilitating performance monitoring of a large database system. The apparatus comprises a processor and a storage device communicatively coupled with the processor. The processor is programmed to (i) retrieve resource usage data points, (ii) calculate an outlier threshold value based upon values of data points, and (iii) determine if the value of each data point is outside of the threshold value. The processor is further programmed to (iv) plot the value of the data point in histogram with a first color when the data point value is determined to be outside of the threshold value, (v) plot the data point value in histogram with a second color when the data point value is determined to be not outside of the threshold value, and (vi) display the histogram containing plotted data point values of the first color and plotted data point values of the second color to enable a user to quickly and easily identify a potential skew condition.

主权项

1. An apparatus for facilitating performance monitoring of a large database system, the apparatus comprising:
a processor; and a storage device communicatively coupled with the processor, wherein the processor is programmed to (i) retrieve a set of resource usage data points, (ii) calculate a first outlier threshold value based upon values of data points from the set of resource usage data points, (iii) determine if the value of each data point of the retrieved set of resource usage data points is outside of the calculated first outlier threshold value, (iv) plot the value of the data point in histogram with a first color when the data point value is determined to be outside of the calculated first outlier threshold value, (v) plot the value of the data point in histogram with a second color which is different from the first color when the data point value is determined to be not outside of the calculated first outlier threshold value, (vi) display the histogram containing plotted data point values of the first color and plotted data point values of the second color which is different from the first color to enable a user to quickly and easily identify a potential skew condition associated with the large database system, (vii) calculate a second outlier threshold value based upon values of data points from the set of resource usage data points, (viii) determine if the value of each data point of the retrieved set of resource usage data points is outside of the calculated second outlier threshold value when a determination has been made that the value of the data point is not outside of the calculated first outlier threshold value, (ix) plot the value of the data point in histogram with a third color when the data point value is determined to be outside of the calculated second outlier threshold value, (x) plot the value of the data point in histogram with the second color when the data point value is determined to be not outside of the calculated second outlier threshold value, and (xi) display the histogram containing plotted data point values of the first color, plotted data point values of the second color, and plotted data point values of the third color to enable a user to quickly and easily identify a potential skew condition associated with the large database system, and wherein the difference between the first and second outlier threshold values define an interquartile range (IQR).