70-465 Latest Exam Braindumps
Question 3: You have a server named Server1 that has 2 processors.You plan to deploy multiple instances of SQL Server 2014 to Server1. Each instance will have multiple
databases.
You need to recommend a method to allocate processor time to each database.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.
A. Resource Governor
B. Max Degree of Parallelism
C. Windows System Resource Manager (WSRM)
D. Processor affinity
Correct Answer: A
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.
Reference: Resource Governor
Incorrect:
D: PROCESS AFFINITY
Enables hardware threads to be associated with CPUs.
