Microsoft
70-465 · Question #123
You have a server named Server1 that has 16 processors. You plan to deploy multiple instances of SQL Server 2014 to Server1. You need to recommend a method to allocate processors to each instance…
The correct answer is A. Processor affinity. CPU affinity management through Windows System Resource Manager is not recommended for SQL Server multi-instance management. Instead, use the processor affinity settings in SQL
Submitted by paula_co· Mar 5, 2026Design and implement database solutions for SQL Server
Question
You have a server named Server1 that has 16 processors. You plan to deploy multiple instances of SQL Server 2014 to Server1. You need to recommend a method to allocate processors to each instance. What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.
Options
- AProcessor affinity
- BWindows System Resource Manager (WSRM)
- CMax Degree of Parallelism
- DResource Governor
How the community answered
(23 responses)- A78% (18)
- C9% (2)
- D13% (3)
Explanation
CPU affinity management through Windows System Resource Manager is not recommended for SQL Server multi-instance management. Instead, use the processor affinity settings in SQL
Topics
#Processor affinity#Resource allocation#SQL Server instance configuration
Community Discussion
No community discussion yet for this question.