Patent ID: 7376682

Claim:
A method for quantifying an impact of wasteful operations in a database, the method comprising: receiving one or more operations that are determined to be wasteful when performed in the database; detecting when one or more wasteful operations are being performed in the database; recording a time value that is spent on a wasteful operation; and generating information that quantifies the impact of a performance problem in the database based on the time value; storing the time value, wherein the time value is used to quantify the impact of a performance problem in the database; wherein the time value measures time spent processing the wasteful operation in the database; generating an accumulated time value associated with the wasteful operation based on the time value; and wherein generating the accumulated time value associated with the wasteful operation comprises adding the time value to another time value associated with another operation, the another operation being a database operation that includes the wasteful operation and at least one or more other wasteful operations.