You have recently removed a SQL 2012 Database Engine instance from a computer running the
Windows Server 2008 R2 operating system. Prior to the removal of the instance, you had configured
affinity so that the default instance used CPU 0 and 1 and the second instance used CPU 2 and 3.
You want to ensure that the default instance can use all processors available to the host.
Which of the following commands would you use to accomplish this goal?
A.
ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = AUTO
B.
ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 2,3
C.
ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,1
D.
ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,4
A
A