70-465 · Question #123
70-465 Question #123: Real Exam Question with Answer & Explanation
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
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
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
Community Discussion
No community discussion yet for this question.