Workload group trend analysis in a database system

• US 20060026179A1
• Filed: 12/30/2004
• Published: 02/02/2006
• Est. Priority Date: 12/08/2003
• Status: Abandoned Application

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Ramesh, Bhashyam, Richards, Anita, Brown, Douglas P.
• Application Number:
  US11/027,896
• Publication Number:
  US 20060026179A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

The described technique is for use in analyzing performance of a database system as it executes requests that are sorted into multiple workload groups, where each workload group has an associated level of service that is desired from the database system. The technique involves gathering data that describes performance metrics for the database system as it executes the requests in at least one of the workload groups, organizing the data in a format that shows changes in the performance metrics over time, and delivering the data in this format for viewing by a human user.

Claims

1. A method for use in analyzing performance of a database system as it executes requests that are sorted into multiple workload groups, where each workload group has an associated level of service that is desired from the database system, the method comprising:

gathering data that describes one or more performance metrics for the database system as it executes the requests in at least one of the workload groups;

organizing the data in a format that shows changes in the performance metrics over time; and

delivering the data in this format for viewing by a human user.

2. The method of claim 1, where gathering data includes gathering data that indicates an average arrival rate for requests in at least one of the workload groups during each of multiple measured time periods.

3. The method of claim 1, where gathering data includes gathering data that indicates an average response time by the database system in completing requests from at least one of the workload groups during each of multiple measured time periods.

4. The method of claim 1, where gathering data includes gathering data that indicates an average amount of CPU time consumed in completing requests from at least one of the workload groups during each of multiple measured time periods.

5. The method of claim 1, where gathering data includes gathering data that indicates a number of requests in at least one of the workload groups for which an actual level of service exceeds the desired level of service during each of multiple measured time periods.

6. The method of claim 1, where gathering data includes gathering data that identifies at least one of the workload groups by name.

7. The method of claim 1, where organizing the data includes placing the data in tabular format, with each tabular row storing one or more performance metrics gathered during one of multiple measured time periods.

8. The method of claim 1, where organizing the data includes placing the data in graphical format, with one graphical axis representing the passage of multiple measured time periods.

9. The method of claim 1, further comprising receiving an instruction from the user to change the format in which the data is organized for display.

10. The method of claim 1, further comprising receiving an instruction from the user to change the data delivered for display from one set of performance metrics to another.

11. A computer program, stored on a tangible storage medium, for use in analyzing performance of a database system as it executes requests that are sorted into multiple workload groups, where each workload group has an associated level of service that is desired from the database system, the program comprising executable instructions that cause a computer to:

gather data that describes one or more performance metrics for the database system as it executes the requests in at least one of the workload groups;

organize the data in a format that shows changes in the performance metrics over time; and

deliver the data in this format for viewing by a human user.

12. The program of claim 11, where, in gathering data, the computer gathers data that indicates an average arrival rate for requests in at least one of the workload groups during each of multiple measured time periods.

13. The program of claim 11, where, in gathering data, the computer gathers data that indicates an average response time by the database system in completing requests from at least one of the workload groups during each of multiple measured time periods.

14. The program of claim 11, where, in gathering data, the computer gathers data that indicates an average amount of CPU time consumed in completing requests from at least one of the workload groups during each of multiple measured time periods.

15. The program of claim 11, where, in gathering data, the computer gathers data that indicates a number of requests in at least one of the workload groups for which an actual level of service exceeds the desired level of service during each of multiple measured time periods.

16. The program of claim 11, where, in gathering data, the computer gathers data that identifies at least one of the workload groups by name.

17. The program of claim 11, where, in organizing the data, the computer places the data in tabular format, with each tabular row storing one or more performance metrics gathered during one of multiple measured time periods.

18. The program of claim 11, where, in organizing the data, the computer places the data in graphical format, with one graphical axis representing the passage of multiple measured time periods.

19. The program of claim 11, where the program enables the computer to receive an instruction from the user to change the format in which the data is organized for display.

20. The program of claim 11, where the program enables the computer to receive an instruction from the user to change the data delivered for display from one set of performance metrics to another.