Automatic performance statistical comparison between two periods

摘要

A technique for automatically generating a report comprising normalized differences in performance statistics between two separate periods. In one embodiment of the invention, database performance statistics are collected on a periodic basis over various time periods. In order to accurately compare database system performance between two discrete periods of time, the difference in the performance statistics of each period are normalized prior to comparing the two periods with each other. By normalizing the statistical differences in each period prior to comparing the differences, periods of different lengths of time as well as different levels of database system load may be compared. In one embodiment, a report is automatically generated which lists the performance statistics being evaluated, the difference in the statistic between each period, the value of each statistical difference as normalized by database time, and the difference between the normalized values.