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

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.

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments