The Resource Governor enables administrators to control and allocate CPU and memory resources to high priority applications. This enables predictable performance to be maintained and helps avoid performance from being negatively affected by resource-intense applications or processes
Prioritize applications, users, and computers competing for the same resources
Prevent runaway queries that hold resources for extended periods of time
Limitations are not enforced when there is no competition for resources