Chapter 40. Managing Workloads with the Resource Governor

In This Chapter

Overview of Resource Governor Resource Governor Components Configuring Resource Governor Monitoring Resource Usage Modifying Your Resource Governor Configuration

If you have ever had a user kick off a runaway report that brought the system to its knees, effectively halting your production online transaction processing (OLTP) activity, you might have wished for a mechanism in SQL Server that would limit the amount of hardware resources allocated to ad hoc reporting requests so that normal production activity was not affected. Such a mechanism could prevent certain processes from consuming too many of the available SQL Server resources, ensuring that your more critical, higher-priority processes would consistently have access to the resources they need.