Chapter 40. Managing Workloads with the Resource Governor
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 ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
