Which feature should you enable and configure so session requests addressed to a specific instance
can be allocated different processor resources based on session request properties?
A.
Resource Governor
B.
Windows System Resource Manager
C.
Processor affinity
D.
I/O affinity
Lol… It should be A or even B.
A
“based on session request properties” can only be resource governor. Processor affinity affects all queries / activities for a given instance.
Agreed
https://msdn.microsoft.com/en-us/library/bb933866.aspx
A.Resource Governor
right ans. will be Processor Affinity
From the microsoft textbook:
2. Correct Answer: A
A. Correct: Resource Governor enables you to allocate session requests to different
resources based on the characteristics of the session request properties.
B. Incorrect: WSRM enables you to allocate different resources to different instances
but does not enable you to allocate different resources based on session requests.
C. Incorrect: Processor affinity enables you to configure the instance to use specific
processors but does not enable you to differentiate resources based on session
request properties.
D. Incorrect: I/O affinity enables you to configure disk I/O to occur by using a specific
processor but does not allow you to differentiate resources based on session
request properties.