Note: This question is part of a series of questions that present the same scenario. Each question in
the series contains a unique solution. Determine whether the solution meets stated goals.
You have a mission-critical application that stores data in a Microsoft SQL Server instance. The application
runs several financial reports. The reports use a SQL Server-authenticated login named Reporting_User. All
queries that write data to the database use Windows authentication.
Users report that the queries used to provide data for the financial reports take a long time to complete. Thequeries consume the majority of CPU and memory resources on the database server. As a result, read-write
queries for the application also take a long time to complete.
You need to improve performance of the application while still allowing the report queries to finish.
Solution: You configure the Resource Governor to limit the amount of memory, CPU, and IOPS used for the
pool of all queries that the Reporting_user login can run concurrently.
Does the solution meet the goal?
A.
Yes
B.
No
Explanation:
SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system
resource consumption. Resource Governor enables you to specify limits on the amount of CPU, physical IO,
and memory that incoming application requests can use.
https://msdn.microsoft.com/en-us/library/bb933866.aspx