How to know a Processor is 2 core or 4 core?

Question

How to know a Processor is 2 core or 4 core?

rambilla4

SSCrazy Eights

Points: 8715
More actions
July 10, 2009 at 12:01 pm

#136161

Hi,
How to know a Processor is 2 core or 4 core? Is the licensing for sql server 2005 is per processor or per core or per socket???
I can see in the device manager, we have 8 processors of name Intel(R) Xeon(R) CPU E5440 @ 2.83GHz.
So how can we know how many cores in this processor or have cores????

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

I can't answer your last question, but with regard to licensing of SQL Server, it is based on physical processors (or sockets if you will).

If you have a dual-processor server with dual core processors, then you need two per server licenses for SQL Server. If you have the same dual-processor server with quad-code processors, you still only need two per server licenses for SQL Server.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

You can also license SL Server per user, and then it doesn't matter how many processors the server has, just the number of users/devices that are accessing the data. Multiplexing doesn't reduce the number of licenses you'd need going per user/device. There reaches a threshold where per processor licensing is more cost effective than per user licensing.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

Well if you know how many processors are in your server then running

xp_msver 'ProcessorCount'

And dividing the number retuend by the # of processors you'll get the cores as that code returns the cores.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Google tells me that the Intel Xeon E5440 is a quad core processor

http://www.google.com/search?q=Xeon+%2BE5440+site%3Aintel.com

First hit on that search page is

http://processorfinder.intel.com/details.aspx?sSpec=SLANS

Considering that device manager shows the total cores, not the total physical processors (my quad core desktop shows 4 processors in device manager), I'd say that you've got two physical sockets in that server.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 5

rambilla4

SSCrazy Eights

Points: 8715

July 10, 2009 at 2:38 pm

#1023349

Thank you..

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 6

You can query WMI to get the processor counts, however - you might need to apply a patch first:

http://support.microsoft.com/kb/932370/

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs