You administer a SQL Server 2008 instance. The server hosts databases for several
mission-critical applications.
You plan to use the Resource Governor to limit the effect of queries that are executed by
Microsoft SQL Server Management Studio.
You need to ensure that that the following requirements are met:
-Queries initiated through SQL Server Management Studio do not exceed 20 percent of CPU
utilization. -Queries initiated by the mission-critical applications are allowed to consume 100
percent of CPU utilization when required.
What should you do?
A.
Alter the default resource pool and set the MAX_CPU_PERCENT option to 20. Assign
this resource pool to the workload group used by the mission-critical applications.
B.
Alter the default resource pool and set the MAX_CPU_PERCENT option to 80. Assign
tins resource pool to the workload group used by SQL Server Management Studio.
C.
Create a new resource pool and set the MAX_CPU_PERCENT option to 20. Assign this
resource pool to the workload group used by SQL Server Management Studio.
D.
Create a new resource pool and set the MAX_CPU_PERCENT option to 80. Assign this
resource pool to the workload group used by the mission-critical applications.