September 15, 2011 at 3:47 am
I have a server with 4 processors. Two instanses of SQL Server 2008 R2 is installed on the server. Now I want to dedicate two processors too one instans and the other two to the other instans.
I go to properties of the instanses and select processors, but what value will I use to dedicate the processors to the instanses? Processor affinity mask or I/O affinity mask?
September 15, 2011 at 5:53 am
Erik Hansson (9/15/2011)
I have a server with 4 processors. Two instanses of SQL Server 2008 R2 is installed on the server. Now I want to dedicate two processors too one instans and the other two to the other instans.I go to properties of the instanses and select processors, but what value will I use to dedicate the processors to the instanses? Processor affinity mask or I/O affinity mask?
Both is you're trying to isolate one instance from another completely.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply