Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

questions regarding config_value for affinity mask Expand / Collapse
Author
Message
Posted Thursday, August 7, 2014 10:13 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 10:12 PM
Points: 59, Visits: 469
Hi All,

I ran ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 2,3 that means the SQL server 2012 is using the 2nd and 3rd CPU's respectively..

Now, when I run sp_configure 'affinity mask' I get the config_value as 12, so how it is getting calculated?

is there a code for each CPU?? wanted to know about this.

Post #1601015
Posted Friday, August 8, 2014 4:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:29 PM
Points: 5,364, Visits: 7,779
Ashif Shaikh (8/7/2014)
Hi All,

I ran ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 2,3 that means the SQL server 2012 is using the 2nd and 3rd CPU's respectively..

Now, when I run sp_configure 'affinity mask' I get the config_value as 12, so how it is getting calculated?

is there a code for each CPU?? wanted to know about this.



You don't need to know about this. Set it to the default and never, ever mess with it. In almost 20 years of consulting on SQL Server the number of times I have seen this set to non-default values correctly is precisely zero.


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1601103
Posted Friday, August 8, 2014 4:26 AM This worked for the OP Answer marked as solution


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 4:31 AM
Points: 8,189, Visits: 16,353
sp_configure is showing the raw bitmap value based on the CPU numbers, they are as follows

exec sp_configure 'affinity mask'

CPU number       7      6      5      4      3      2      1      0
Bit map 128 64 32 16 8 4 2 1

So, CPU 2 and 3 equate to 8 + 4 = 12
CPU 2, 5 and 7 equate to 128 + 32 + 4 = 164


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1601112
Posted Friday, August 8, 2014 4:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 10:12 PM
Points: 59, Visits: 469
Thanks, A Lot Perry


Post #1601114
Posted Friday, August 8, 2014 4:37 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 4:31 AM
Points: 8,189, Visits: 16,353
you're welcome

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1601116
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse