Administering a SQL Database Infrastructure — Question 172

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.

Answer options

• A. Processor affinity
• B. Windows System Resource Manager (WSRM)
• C. Max Degree of Parallelism
• D. Resource Governor

Correct answer: A

Explanation

Processor affinity is the correct choice because it allows you to assign specific processors to particular SQL Server instances, ensuring efficient resource use. The other options, while useful for other resource management tasks, do not directly allocate processors to instances in the same manner as processor affinity does.