Question
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
Replies
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
Hi,
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.