PrepAway - Latest Free Exam Questions & Answers

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.

PrepAway - Latest Free Exam Questions & Answers

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)


Leave a Reply