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 multipledatabases.
You need to recommend a method to set limits on processor time for each database.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.
A.
processor affinity
B.
Max Degree of Parallelism
C.
Windows System Resource Manager (WSRM)
D.
Resource Governor
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 answers:
Not A: Processor affinity cannot be used to assign databases to processors.
Not B: The Microsoft SQL Server max degree of parallelism (MAXDOP) configuration option controls the
number of processors that are used for the execution of a query in a parallel plan. It is not used limit the
processor time for a database.
Not C: You can use Windows System Resource Manager to allocate processor and memory resources to
applications, users, Remote Desktop Services sessions, and Internet Information Services (IIS) application
pools. You cannot use Windows System Resource Manager to allocate resources for a database.
Resource Governor
https://msdn.microsoft.com/en-us/library/bb933866(v=sql.120).aspx