70-465 · Question #152
70-465 Question #152: Real Exam Question with Answer & Explanation
The correct answer is C: Processor affinity. To allocate session requests for a specific instance to different processor resources based on their properties, processor affinity is the feature that allows binding processes or threads to specific CPU cores.
Question
Which feature should you enable and configure so session requests addressed to a specific instance can be allocated to different processor resources based on session request properties?
Options
- AResource Governor
- BWindows System Resource Manager
- CProcessor affinity
- DI/O affinity
Explanation
To allocate session requests for a specific instance to different processor resources based on their properties, processor affinity is the feature that allows binding processes or threads to specific CPU cores.
Common mistakes.
- A. Resource Governor is a SQL Server feature used to manage and limit resource consumption (CPU, I/O, memory) for different workloads, but it does not directly bind specific session requests to particular processor cores.
- B. Windows System Resource Manager (WSRM) was a deprecated Windows Server feature for general resource allocation across applications, not specifically for binding session requests of an instance to distinct processor cores.
- D. I/O affinity relates to managing I/O operations and their completion ports or resources, not the allocation of general session processing requests to specific CPU resources.
Concept tested. Processor affinity configuration for workload isolation
Reference. https://learn.microsoft.com/en-us/sql/database/managing-cpu-affinity
Topics
Community Discussion
No community discussion yet for this question.