Granted Patent B1

US 7,562,094 · App. 10/750,346 · Granted Jul 14, 2009

Abstract

Claims (52)

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.

2. The method of claim 1 wherein the performance data comprises an I/O wait.

3. The method of claim 1 wherein the performance data comprises an application lock wait.

4. The method of claim 1 wherein the performance data comprises a resource contention.

5. The method of claim 1 , further comprising:

correlating the collected performance data to specific database objects of the plurality of database objects.

6. A computer-readable storage medium comprising

program instructions, wherein the program instructions are computer-executable to implement:

collecting and storing performance data for a plurality of database objects in a database server computer system, 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.

7. The computer-readable storage medium of claim 6 , 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.

8. The computer-readable storage medium of claim 6 , wherein tuning the problematic database object to improve performance of access to the stored data in the database server computer system comprises creating a new access path to the problematic database object.

9. The computer-readable storage medium of claim 6 , 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 heavily loaded storage components to less loaded storage components.

10. The computer-readable storage medium of claim 6 , wherein the performance data comprises an UO wait.

11. The computer-readable storage medium of claim 6 , wherein the performance data comprises an application lock wait.

12. The computer-readable storage medium of claim 6 , wherein the performance data comprises a resource contention.

13. The computer-readable storage medium of claim 6 , wherein the program instructions are further computer-executable to implement:

correlating the collected performance data to specific database objects of the plurality of database objects.

14. A performance management system, comprising:

a database server comprising a plurality of database objects, wherein each of the plurality of database objects comprises an aggregation of stored data; and

a performance warehouse which stores performance data for the plurality of database objects, wherein the performance data comprises a plurality of access times;

at least one processor; and a memory coupled to the at least one processor, wherein the memory stores program instructions that are executable by the at least one processor to:

monitor data access times using a software agent operative to capture performance data for the database objects;

correlate performance data to the access times;

detect a performance problem in the database server in response to the correlation;

identify 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;

tune the problematic database object to improve performance of access to the stored data in the database server;

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.

15. The performance management system of claim 14 , wherein tuning the problematic database object to improve performance of access to the stored data in the database server comprises moving the problematic database object from nonvolatile storage to volatile storage for improved speed of access.

16. The performance management system of claim 14 , wherein tuning the problematic database object to improve performance of access to the stored data in the database server comprises creating a new access path to the problematic database object.

17. The performance management system of claim 14 , wherein tuning the problematic database object to improve performance of access to the stored data in the database server comprises moving the problematic database object from heavily loaded storage components to less loaded storage components.

18. The performance management system of claim 14 , wherein the performance data comprises an UO wait.

19. The performance management system of claim 14 , wherein the performance data comprises an application lock wait.

20. The performance management system of claim 14 , wherein the performance data comprises a resource contention.

21. The performance management system of claim 14 , wherein the performance data is correlated to specific database objects of the plurality of database objects.

22. A system for tuning database objects, the system comprising:

means for collecting and storing performance data for a plurality of database objects in a database server computer system, wherein the performance data comprises a plurality of access times, wherein each of the plurality of database objects comprises an aggregation of stored data;

means for correlating said database objects to said access times;

means for detecting a performance problem in the database server computer system in response to said correlation;

means for 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; and

means for 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.

Assignments (13)