Designing Database Solutions for Microsoft SQL Server — Question 14

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.

Answer options

Correct answer: A

Explanation

Processor affinity allows you to bind specific SQL Server instances to designated processors, ensuring efficient resource usage and optimal performance. While WSRM, Max Degree of Parallelism, and Resource Governor can manage resources as well, they do not provide the direct control over processor allocation that processor affinity does.