sql server cores and processors

Category: sql server documentation


mastanvali shaik on Fri, 05 Sep 2014 12:36:47

Hello All,

all of our servers are 12 cores but in sql server 2008 r2 properties it shows 24 processors ,kindly explain.

some one say's 1 core=2 processors is it correct or not?.

Thanks in Advance!!!

mastanvali shaik


Satish Kartan, MCITP on Fri, 05 Sep 2014 13:04:31

1 core can be presented as two logical processors with hyperthreading. Run the following query and check the cpu_count and hyperthreaded_ratio:

select * from sys.dm_os_sys_info

Shanky_621 on Fri, 05 Sep 2014 13:11:14


Are you same person Baraiya Krit who posted below same question I have frequently observed question posted by you and Baraiya are same. If such is the case both threads should be merged and you should note not to post same question with different profile otherwise i have to report that as spam and your profile would be deleted. If such is case you are wasting people time


If you are from same firm and different person why not post one question.

Moderators please have a look

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Technet Articles

mastanvali shaik on Fri, 05 Sep 2014 13:53:11

Sorry for disturb you,

mastanvali shaik on Fri, 05 Sep 2014 13:56:40

he is one my friend we both are working on sql server dba, any doubts ,topics we discussed and posted on sites.

sorry for posting same questions.

next time I will take care about that.