Setting Affinity

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

frederico_fonseca SSCoach Points: 16154 More actions · Answer 1

question is incorrect and as such answer is also incorrect - both settings are used for SQL 2019 - one for first 32 cpu's, second for the ones above.

2 answers are correct depending on number of cpu's on the server

Louis Hillebrand SSCarpal Tunnel Points: 4982 More actions · Answer 2

I agree with Frederico, the 'correct answer' is not correct, the no. of processors is not mentioned in the question.

far SSCertifiable Points: 6575 More actions · Answer 3

The question is not formulated correctly and therefore gives a wrong answer

Rune Bivrin SSCrazy Eights Points: 8511 More actions · Answer 4

Also, for SQL Server 2019, you should use ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU=;

The sp_configure option will be deprecated.

Just because you're right doesn't mean everybody else is wrong.

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 5

Apologies, the question wasn't well phrased. Modified this.

The explanation notes ALTER SERVER CONFIGURATION is the better option.