Microsoft Exam 70-465 Topic 2 Question 5 Discussion

Actual exam question for Microsoft's 70-465 exam

Question #: 5
Topic #: 2

[All 70-465 Questions]

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.

AProcessor affinity

BWindows System Resource Manager (WSRM)

CMax Degree of Parallelism

DResource Governor

Show Suggested Answer

Suggested Answer: A

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.

by Mirta at May 04, 2022, 07:29 AM

Limited Time Offer

25%

Off

Get Premium 70-465 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!