Exam 70-764 topic 1 question 253 discussion

Actual exam question from Microsoft's 70-764

Question #: 253
Topic #: 1

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

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 TheSwedishGuy at Jan. 31, 2020, 2:27 p.m.

Comments

Submit Cancel

TheSwedishGuy

5 years, 4 months ago

Resource governor = Specifies how much of a resource you get, not which resources you get.

upvoted 2 times

...

TheSwedishGuy

5 years, 4 months ago

Resource governor = Resource Governor enables you to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can use. It has nothing to do with assigning cores to instances, but has to do with how much CPU transactions can use. https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor?view=sql-server-ver15 Processor affinity = Allocate cores to instances.

upvoted 3 times

...