Resource Governor Enhancements
SQL Server 2012 provides enhancements to the Resource Governor that enable you to more effectively govern performance, especially for machines with a large number of CPU cores. The enhancements include the following:
Support for up to 64 resource pools, an increase from the previous maximum of 20, to better enable partitioning larger machines between more workloads
A new CAP_CPU_PERCENT
option for resource pools to provide a means of setting a hard-cap limit on CPU resource usage, which can provide greater predictability ...
Get Microsoft® SQL Server 2012 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.