What should you include in the recommendation?

You have a server named Server1 that has 2 processors.
You plan to deploy multiple instances of SQL Server 2014 to Server1. Each instance will
have multiple databases.
You need to recommend a method to allocate processor time to each database.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.

You have a server named Server1 that has 2 processors.
You plan to deploy multiple instances of SQL Server 2014 to Server1. Each instance will
have multiple databases.
You need to recommend a method to allocate processor time to each database.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.

A.
Resource Governor

B.
Max Degree of Parallelism

C.
Windows System Resource Manager (WSRM)

D.
Processor affinity

Explanation:

SQL Server Resource Governor is a feature than you can use to manage SQL Server
workload and system resource consumption. Resource Governor enables you to specify
limits on the amount of CPU, physical IO, and memory that incoming application requests
can use.
Incorrect:
D: PROCESS AFFINITY
Enables hardware threads to be associated with CPUs.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


adityomagnet@gmail.com

[email protected]

Option D is right

Skippo

Skippo

Resource Governor:: “…a method to allocate processor time to each database”

This is not asking about prioritizing CPU usage by server instances (Processor Affinity)

Skippo

Skippo

NOPE!! Option A is the correct answer. Option D is not right in this scenario: Multiple Instances, each having Multiple Databases.

Muraru Adrian

Muraru Adrian

A is correct.