Affinity Mask

Last Post 04 Dec 2007 03:23 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
waynewchan2
New Member
New Member

--
13 Nov 2007 06:26 AM
Hi.

Have a problem whereby I cannot set the affinity mask.

This is because the SQL Server 2005 use to point at 8CPUs.
And it was configure to use the 7th and 8th CPU for affinity and Affinity I/O masks.

Then, the system was downgraded to 4CPUs without changing the above affinity masks.
Which means somehow SQL Server tries to map to the not available 7th and 8th CPU during re-boot,
SQL server detects this and puts the following entries in the LOG:

>>> For AFFINITY MASK it fails and defaults to factory setting
initconfig: Warning: affinity mask specified is not valid. Defaulting to no affinity. Use sp_configure 'affinity mask' or 'affinity64 mask' to configure the system to be compatible with the CPU mask on the system. You can also configure the system based on the number of licensed CPUs.
>>>

>>> For AFFINITY I/O it succeeds!!!
I/O affinity turned on, processor mask 0x000000c0. Disk I/Os will execute on CPUs per affinity I/O mask/affinity64 mask config option. This is an informational message only; no user action is required.
>>>

The above results in the sys.configurations of:
>>>
SHOW ADVANCED OPTIONS: VALUE=1; VALUE_IN_USE=0
AFFINITY MASK: VALUE=192; VALUE_IN_USE=0
AFFINITY I/O MASK: VALUE=192; VALUE_IN_Use=192
>>>

The problems is:
1. I can no longer configure the AFFINITY (either thru sp_configure or Management Studio).
2. Because I need to change "Show Advanced Options"=1, this I can do, but when I run RECONFIGURE afterwards, I get the error message:
>>>
The affinity mask specified does not match the CPU mask on this system
>>>
3. I cannot change the AFFINITY when I CANNOT set "show advanced options" thru RECONFIGURE (or RECONFIGURE WITH OVERRIDE) or a server reboot.
4. The only other option is to give the SQL Server back 8CPU and then configure that - but it is too late, since the new hardware does not take more than 4CPUs!!!

Can anyone advise how I can:
1. Force the "show advanced options"?
2. allow me to change the affinity?

Thks All!
SQLUSA
New Member
New Member

--
04 Dec 2007 03:23 AM
Let us know if minimum start works.

If not you may have to reinstall SQL Server.



Kalman Toth, MCDBA, MCITP
SQL Server 2005 Training - http://www.sqlusa.com
You are not authorized to post a reply.

Acceptable Use Policy