nerdexam
Microsoft

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.

Submitted by femi9· Mar 5, 2026Design and implement database solutions for SQL Server

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

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    94% (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.

AResource Governor

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.

BWindows System Resource Manager

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.

CProcessor affinityCorrect

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.

DI/O affinity

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

#processor affinity#resource allocation#performance tuning#SQL Server configuration

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice