Microsoft
70-465 · Question #130
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…
The correct answer is A. Resource Governor. 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. D: PROCESS…
Submitted by layla.eg· Mar 5, 2026Design and implement database solutions for SQL Server
Question
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.
Options
- AResource Governor
- BMax Degree of Parallelism
- CWindows System Resource Manager (WSRM)
- DProcessor affinity
How the community answered
(22 responses)- A82% (18)
- B9% (2)
- C5% (1)
- D5% (1)
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. D: PROCESS AFFINITY Enables hardware threads to be associated with CPUs.
Topics
#Resource management#Resource Governor#CPU allocation#multi-instance deployment
Community Discussion
No community discussion yet for this question.