Patent ID: 7562094
Filing Date: 2009-07-14
Classification: G06F,Y10S

Abstract:
1. A method for tuning database objects, the method comprising: operating agent software on a database server computer system, said agent software operative to collect and store performance data for a plurality of database objects, wherein the performance data comprises a plurality of access times, wherein each of the plurality of database objects comprises an aggregation of stored data; correlating the access times to the database objects; detecting a performance problem in the database server computer system in response to the correlating; identifying a problematic database object of the plurality of database objects using the performance data for the plurality of database objects, wherein the problematic database object is related to the performance problem; tuning the problematic database object to improve performance of access to the stored data in the database server computer system; wherein tuning the problematic database object to improve performance of access to the stored data in the database server computer system comprises moving the problematic database object from nonvolatile storage to volatile storage for improved speed of access, creating a new access path to the problematic database object, and moving the problematic database object from heavily loaded storage components to less loaded storage components.