default affinitymask and affinityIOmask settings

Through the GUI for Server properties on my sql 2005 64 bit server,
I see that under processors, both set processor affinity mask and set IO
affinity mask are checked.
Is that the default ?
Also when I run
select name,value,value_in_use from sys.configurations where name like
'affinity%'
Output is as below :
affinity mask 0 0
affinity64 mask 0 0
affinity I/O mask 0 0
affinity64 I/O mask 0 0
So something does not add up. Is value the default and value_in_use the
current setting and if so, I would think that value_in_use should be 1.
I even restarted SQL. But it has the same results.Hi Hassan
All the of the affinity mask settings are bit MASKS, not just booleans. If
you set them to something non-zero, you are telling SQL Server which
processors to use. Each bit set means the corresponding processor will be
available to SQL Server.
The default is 0, which means that SQL Server will use all the available
processors.
Can you clarify what is 'set' in your GUI screen. I do not see anything that
says 'set processor affinity mask'; I have something that says
'Automatically set processor affinity mask for all processors' which is
basically telling SQL Server to use the 0 value, rather than having YOU
choose specific processors.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
> Through the GUI for Server properties on my sql 2005 64 bit server,
> I see that under processors, both set processor affinity mask and set IO
> affinity mask are checked.
> Is that the default ?
> Also when I run
> select name,value,value_in_use from sys.configurations where name like
> 'affinity%'
> Output is as below :
> affinity mask 0 0
> affinity64 mask 0 0
> affinity I/O mask 0 0
> affinity64 I/O mask 0 0
> So something does not add up. Is value the default and value_in_use the
> current setting and if so, I would think that value_in_use should be 1.
> I even restarted SQL. But it has the same results.
>
>|||Yes its the one you mentioned i.e. automatically set processor affinity mask
and automatically set IP affinity mask for all processors and they both are
checked for me.
Is that default ?
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
> Hi Hassan
> All the of the affinity mask settings are bit MASKS, not just booleans. If
> you set them to something non-zero, you are telling SQL Server which
> processors to use. Each bit set means the corresponding processor will be
> available to SQL Server.
> The default is 0, which means that SQL Server will use all the available
> processors.
> Can you clarify what is 'set' in your GUI screen. I do not see anything
> that says 'set processor affinity mask'; I have something that says
> 'Automatically set processor affinity mask for all processors' which is
> basically telling SQL Server to use the 0 value, rather than having YOU
> choose specific processors.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Hassan" <hassan@.hotmail.com> wrote in message
> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>> Through the GUI for Server properties on my sql 2005 64 bit server,
>> I see that under processors, both set processor affinity mask and set IO
>> affinity mask are checked.
>> Is that the default ?
>> Also when I run
>> select name,value,value_in_use from sys.configurations where name like
>> 'affinity%'
>> Output is as below :
>> affinity mask 0 0
>> affinity64 mask 0 0
>> affinity I/O mask 0 0
>> affinity64 I/O mask 0 0
>> So something does not add up. Is value the default and value_in_use the
>> current setting and if so, I would think that value_in_use should be 1.
>> I even restarted SQL. But it has the same results.
>>
>|||Yes
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:uFWlFM2PIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Yes its the one you mentioned i.e. automatically set processor affinity
> mask and automatically set IP affinity mask for all processors and they
> both are checked for me.
> Is that default ?
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
>> Hi Hassan
>> All the of the affinity mask settings are bit MASKS, not just booleans.
>> If you set them to something non-zero, you are telling SQL Server which
>> processors to use. Each bit set means the corresponding processor will
>> be available to SQL Server.
>> The default is 0, which means that SQL Server will use all the available
>> processors.
>> Can you clarify what is 'set' in your GUI screen. I do not see anything
>> that says 'set processor affinity mask'; I have something that says
>> 'Automatically set processor affinity mask for all processors' which is
>> basically telling SQL Server to use the 0 value, rather than having YOU
>> choose specific processors.
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://sqlblog.com
>>
>> "Hassan" <hassan@.hotmail.com> wrote in message
>> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>> Through the GUI for Server properties on my sql 2005 64 bit server,
>> I see that under processors, both set processor affinity mask and set IO
>> affinity mask are checked.
>> Is that the default ?
>> Also when I run
>> select name,value,value_in_use from sys.configurations where name like
>> 'affinity%'
>> Output is as below :
>> affinity mask 0 0
>> affinity64 mask 0 0
>> affinity I/O mask 0 0
>> affinity64 I/O mask 0 0
>> So something does not add up. Is value the default and value_in_use the
>> current setting and if so, I would think that value_in_use should be 1.
>> I even restarted SQL. But it has the same results.
>>
>>
>