70-465 · Question #152
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?
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
Options
- AResource Governor
- BWindows System Resource Manager
- CProcessor affinity
- DI/O affinity
How the community answered
(35 responses)- A3% (1)
- B3% (1)
- C94% (33)
Why each option
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.
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.
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.
Processor affinity allows an administrator to bind a process, or specific threads within a process (like those handling session requests for an instance), to a designated set of CPU cores. This enables the allocation of different session request properties to specific processor resources, ensuring controlled and optimized resource utilization.
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
Source: https://learn.microsoft.com/en-us/sql/database/managing-cpu-affinity
Topics
Community Discussion
No community discussion yet for this question.