QuestionQ120

VerifiedDatabase Management and Maintenance

A database administrator has configured a Resource Governor with three resource pools. The first resource pool has minimum CPU and memory values of 25%. The second resource pool has minimum CPU and memory values of 35%. The database administrator wants to assign the maximum CPU and maximum resource-pool values to the third resource. Which of the following is the maximum memory the database administrator should assign to the third resource?

Explanation

For a SQL Server Resource Governor resource pool, MAX_MEMORY_PERCENT can be configured from its minimum value through 100%. Only the combined MIN_MEMORY_PERCENT reservations across all pools must not exceed 100%; the existing 25% and 35% minimum reservations do not prevent configuring the third pool’s maximum memory at 100%, though its effective maximum can be reduced by other pools’ reservations.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!