70-465 · Question #76
You need to enable the Developers to assign SQL Server instances on MainDB3 and MainDB4 to specific processors on the servers. What should you configure?
The correct answer is D. Processor Affinity. To assign SQL Server instances to specific processors on the servers, you should configure Processor Affinity.
Question
Options
- AWindows System Resource Manager (WSRM)
- BResource Governor
- CA Maintenance Plan
- DProcessor Affinity
How the community answered
(48 responses)- A4% (2)
- B2% (1)
- C10% (5)
- D83% (40)
Why each option
To assign SQL Server instances to specific processors on the servers, you should configure Processor Affinity.
Windows System Resource Manager (WSRM) is used to manage and allocate server resources among users and applications at a higher level, rather than directly binding a specific process to particular CPU cores.
Resource Governor is a SQL Server feature used to manage resource consumption (CPU, I/O, memory) *within* a SQL Server instance for different workloads, not to assign the SQL Server instance itself to specific processors on the host.
A Maintenance Plan in SQL Server is used for automating administrative tasks like backups, index rebuilding, and integrity checks, and has no functionality related to processor assignment.
Processor affinity is an operating system feature that allows you to bind a specific process, such as a SQL Server instance, to run on a designated set of CPUs or CPU cores. This directly fulfills the requirement of assigning SQL Server instances to specific processors on the server.
Concept tested: SQL Server Processor Affinity Configuration
Source: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/affinity-mask-server-configuration-option
Topics
Community Discussion
No community discussion yet for this question.