You administer a Microsoft SQL Server database that hosts an order-processing application.
Employees in the order entry group perform real-time data entry for customers. Employees
in the reporting group run historical reports.
Employees in the order entry group report of poor performance when the reporting group
runs reports.
You need to limit the amount of CPU and RAM used by the reporting group.
What should you do?
A.
Implement Resource Governor by using a Resource Pool assigned to the users of the
reporting group to limit the amount of CPU/RAM they can use.
B.
Use sp_dbmmonitoraddmonitoring to set up a monitoring process to kill the reporting
group’s queries that pass a given threshold.
C.
Create a set of views in a new schema, and then alter the queries of the reporting group
to use these views.
D.
Implement Policy Based Management by using the Server Performance facet.