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
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.
Server Properties (Processors Page)