Explanation:You can disable the Resource Governor by using either SQL Server Management Studio or Transact-SQL. 8. ____________ is a hard cap limit on the CPU bandwidth for all requests in the resource pool.
A. MIN_CPU_PERCENT
B. CAP_CPU_PERCENT
C. MAX_CPU_PERCENT
D. MAX_MEMORY_PERCENT
Answer:A
Explanation:You can disable the Resource Governor by using either SQL Server Management Studio or Transact-SQL. 8. ____________ is a hard cap limit on the CPU bandwidth for all requests in the resource pool.
A. MIN_CPU_PERCENT B. CAP_CPU_PERCENT C. MAX_CPU_PERCENT D. MAX_MEMORY_PERCENT
Explanation:Workloads associated with the pool can use CPU capacity above the value of MAX_CPU_PERCENT if it is available, but not above the value of CAP_CPU_PERCENT. 9. ___________ lets you affinitize a resource pool to one or more schedulers or NUMA nodes for greater isolation of CPU resources.