Workload manager for relational database management systems

• US 20070299812A1
• Filed: 06/26/2007
• Published: 12/27/2007
• Est. Priority Date: 06/26/2006
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Datallegro Incorporated (Microsoft Corporation)
• Inventors: Salch, David
• Application Number:
  US11/823,227
• Publication Number:
  US 20070299812A1
• 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

A relational database workload manager is provided for dynamically managing processing priorities assigned to queries executing within a relational database management system (RDBMS). The workload manager monitors executing query process threads and at set time intervals reduces the processing priority assigned to each executing query. This automated method of managing relational database queries allows short executing queries within a mixed database workload to remain relatively quick without complicated setup and management.

Claims

1. A method for managing a relational database workload, the method comprising the steps of:

monitoring executing queries in a relational database management system; and

reducing a priority assigned to each executing query at set time intervals.

2. The method for managing a relational database workload according to claim 1, wherein said monitoring step is executed at the set time intervals.

3. The method for managing a relational database workload according to claim 1, wherein said monitoring step comprises monitoring threads associated with respective executing queries.

4. The method for managing a relational database workload according to claim 1, wherein the set time intervals are administrator defined.

5. The method for managing a relational database workload according to claim 1, wherein said reducing step reduces the priority assigned to each executing query by an administrator-defined amount.

6. The method for managing a relational database workload according to claim 1, wherein said monitoring step comprises monitoring executing queries submitted by a specified group of users, and

wherein said reducing step comprises reducing the priority assigned to each executing query submitted by the specified group of users.

7. The method for managing a relational database workload according to claim 1, wherein administrator-specified queries are excluded from said reducing step.

8. A relational database workload manager, comprising:

a processing system configured to monitor executing queries in a relational database management system and to reduce a priority assigned to each executing query at set time intervals.

9. The relational database workload manager according to claim 8, wherein said processing system is configured to monitor the executing queries at the set time intervals.

10. The relational database workload manager according to claim 8, wherein said processing system is configured to monitor threads associated with respective executing queries.

11. The relational database workload manager according to claim 8, wherein the set time intervals are administrator defined.

12. The relational database workload manager according to claim 8, wherein said processing system is configured to reduce the priority assigned to each executing query by an administrator-defined amount.

13. The relational database workload manager according to claim 8, wherein said processing system is configured to monitor executing queries submitted by a specified group of users and to reduce the priority assigned to each executing query submitted by the specified group of users.

14. The relational database workload manager according to claim 8, wherein said processing system is configured to leave the priority assigned to administrator-specified queries unchanged.

15. A machine-readable medium comprising instructions executable by a processing system in a relational database workload manager, the instructions comprising the steps of:

monitoring executing queries in a relational database management system; and

reducing a priority assigned to each executing query at set time intervals.

16. The machine-readable medium according to claim 15, wherein said monitoring step is executed at the set time intervals.

17. The machine-readable medium according to claim 15, wherein said monitoring step comprises monitoring threads associated with respective executing queries.

18. The machine-readable medium according to claim 15, wherein the set time intervals are administrator defined.

19. The machine-readable medium according to claim 15, wherein said reducing step reduces the priority assigned to each executing query by an administrator-defined amount.

20. The machine-readable medium according to claim 15, wherein said monitoring step comprises monitoring executing queries submitted by a specified group of users, and wherein said reducing step comprises reducing the priority assigned to each executing query submitted by the specified group of users.

21. The machine-readable medium according to claim 15, wherein administrator-specified queries are excluded from said reducing step.