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.

2 Comments on “What should you include in the recommendation?


Leave a Reply