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.