Valid 70-765 Dumps shared by ExamDiscuss.com for Helping Passing 70-765 Exam! ExamDiscuss.com now offer the newest 70-765 exam dumps, the ExamDiscuss.com 70-765 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-765 dumps with Test Engine here:
You are the administrator of a Microsoft SQL Server 2014 server. Some applications consume significant resources. You need to manage the server workload by restricting resource-intensive applications You need to dynamically limit resource consumption. What should you do?
Correct Answer: A
In the SQL Server Resource Governor, a resource pool represents a subset of the physical resources of an instance of the Database Engine. Resource Governor enables you to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can use within the resource pool. Each resource pool can contain one or more workload groups. When a session is started, the Resource Governor classifier assigns the session to a specific workload group, and the session must run using the resources assigned to the workload group. References:https://docs.microsoft.com/en-us/sql/relational-databases/resource- governor/resource-governor-resource-pool