RESOURCE GOVERNOR CONFIGURATION MODEL

• US 20080209428A1
• Filed: 02/27/2007
• Published: 08/28/2008
• Est. Priority Date: 02/27/2007
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Baryshnikov, Boris, Surna, Aleksandras, Verbitski, Alexandre, Rajamani, Ravishankar, Choe, In-Jerng
• Granted Patent: US 8,065,682 B2
• Time in Patent Office: Days
• US Class Current: 718/104
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06F 2209/5011 Pool
• CPC Class Codes: G06F 9/5027 the resource being a machine, e.g. CPUs, Servers, Terminals

Abstract

A database can have multiple requests applied at one time. Each of these requests requires a specific amount of server resources. There can be a differentiation of user-submitted workloads between each other. These workloads are a set of queries submitted by different users. Each query can have specific resource limits. In addition, each set can have specific resource limits.

Claims

1. A system, comprising:

a receiving component that inputs a request; and

a governor component that assigns each incoming request to a workload group and each workload group to a resource pool.

2. The system of claim 1, wherein the governor component further comprises a recognition component that determines there is an incoming request

3. The system of claim 1, wherein the governor component further comprises an association component that classifies the request with a workload group based on classification logic.

4. The system of claim 3, wherein the governor component further comprises an optimization component that classifies the request with a workload group based on previous classifications.

5. The system of claim 3, wherein the governor component further comprises an umbrella component that classifies a request that is not classified by the association component.

6. The system of claim 1, wherein the governor component further comprises an umbrella component that classifies a request that is for the benefit of a server.

7. The system of claim 1, wherein the governor component further comprises an assignment component that assigns a resource pool to a workload group.

8. The system of claim 1, wherein the governor component further comprises a communication component that dialogues to set policies of the governor component.

9. The system of claim 1, further comprising an authorization component that determines if a request can be made on a server.

10. The system of claim 1, further comprising an administration component that enables the setting of policies for the governor component.

11. A method, comprising:

running a classification function to associate a request to a workload group; and

assigning the workload group to a resource pool.

12. The method of claim 11, further comprising defining a policy for limiting resources for the request.

13. The method of claim 12, further comprising implementing the policy upon the workload group that contains the request.

14. The method of claim 11, further comprising authenticating that the request can take place.

15. The method of claim 11, further comprising receiving a request that contains at least one query.

16. The method of claim 11, further comprising checking if the request is for benefit of a server.

17. The method of claim 16, further comprising placing a request for benefit of a server into a system workgroup.

18. The method of claim 11, further comprising checking if a request was successfully associated.

19. The method of claim 18, further comprising placing a request that was not successfully associated in a default workgroup.

20. A system, comprising:

means for receiving a request on a database server;

means for applying the request to a workload group; and

means for applying the workload group to a resource pool.