You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. Domain.com contains quite a few databases that are utilized by applications. You
are planning to use the Resource Governor to cut the result of searches. These searches are run
via Microsoft SQL Server Management Studio. However, the characteristics should be as follows:
The searches done by the SQL Server Management Studio should not exceed 40 % of CPU
utilization and the applications need of 200 % CPU utilization may be allowed when needed.
You need to comply with the Domain.com needs.
What should you do?
A.
You should consider developing a new resource pool and set up the MAX_CPU_PERCENT
selection to 60.and grant this resource pool to the workload group.
B.
You should consider developing a new resource pool and set up the MAX_CPU_PERCENT
selection to 40.and grant this resource pool to the workload group.
C.
You should consider developing a default resource pool and set up the MAX_CPU_PERCENT
selection to 60.and grant this resource pool to the workload group.
D.
You should consider developing a default resource pool and set up the MAX_CPU_PERCENT
selection to 40.and grant this resource pool to the workload group.