You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance that includes an acquiring database and a selling database.
After setting the Resource Governor up to reduce the maximum CPU search time permitted for the
applications, you notice that some of the reports of the acquiring application does not execute
successfully.
You need to ensure that the Resource Governor settings are suitably altered to permit more CPU
time for the acquiring application.
Which of the following actions should you take?
A.
You should consider making changes to the resource pool that is utilized by the acquiring
application.
B.
You should consider making changes to the workload group that is utilized by the acquiring
application.
C.
You should consider making changes to the workload group that is utilized by the selling
application.
D.
You should consider making changes to the resource pool that is utilized by the selling
application.
Explanation:
.. why not A ?
@see http://www.mssqltips.com/sqlservertip/1720/handling-workloads-on-sql-server-2008-with-resource-governor/