What should you include in the recommendation?

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.
A . Processor affinity
B . Windows System Resource Manager (WSRM)
C . Max Degree of Parallelism
D . Resource Governor

View Answer

Answer: A

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 Server.