Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Today @ 8:17 PM
Points: 53, Visits: 287
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:20 AM
Points: 4,437, Visits: 6,339
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:53 PM
Points: 6,630, Visits: 14,205
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: Today @ 8:17 PM
Points: 53, Visits: 287
Thanks, A Lot Perry


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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:53 PM
Points: 6,630, Visits: 14,205
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