Granted Patent B1

US 8,005,860 · App. 12/475,293 · Granted Aug 23, 2011

Abstract

Claims (41)

1. A method comprising:

operating agent software on a server computer system, said agent software operative to collect and store performance data for a plurality of database objects on the server, wherein the performance data includes a plurality of access times;

correlating the access times to the database objects;

detecting a performance problem in the server computer system in response to the correlating;

identifying a problematic database object of the database objects using the performance data for the database objects, wherein the problematic database object is related to the performance problem;

creating a new access path to the problematic database object and either moving the problematic database object from nonvolatile storage to volatile storage for improved speed of access or 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 processor readable storage device having processor readable code embodied on said processor readable storage device, said processor readable code for programming one or more processors to perform a method comprising:

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;

creating a new access path to the problematic database object and either moving the problematic database object from nonvolatile storage to volatile storage for improved speed of access or moving the problematic database object from heavily loaded storage components to less loaded storage components.

7. The device 6 , wherein the performance data comprises an I/O wait.

8. The device of claim 6 , wherein the performance data comprises an application lock wait.

9. The device of claim 6 , wherein the performance data comprises a resource contention.

10. The device 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.

11. A 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;

create a new access path to the problematic database object and either move the problematic database object from nonvolatile storage to volatile storage for improved speed of access or move the problematic database object from heavily loaded storage components to less loaded storage components.

12. The performance management system of claim 11 , wherein the performance data comprises an I/O wait.

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

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

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

16. 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 creating a new access path to the problematic database object and

means for either moving the problematic database object from nonvolatile storage to volatile storage for improved speed of access or moving the problematic database object from heavily loaded storage components to less loaded storage components.

Assignments (11)