SQL Server 2008 vs R2 - Processors - cpu_count

Question

SQL Server 2008 vs R2 - Processors - cpu_count

Viewing 15 posts - 16 through 30 (of 30 total)

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

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 1

SQL Kiwi (11/15/2011)
SQLSeTTeR (11/14/2011)
I have four SQL servers built. Two of the servers are built with SQL 2008 and the other two are built with SQL 2008 R2. The two that are built with R2 are seeing 80 cpu_count. (Which is correct) The other two that are built with SQL 2008 one is seeing cpu_count = 20 and the other is seeing cpu_count = 40. Any ideas?
SQL Server 2008 R2 added support for more than 64 logical processors (= schedulers).

Does this mean SQL 2008 (regular) will never show more than 64 processors?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

SQLSeTTeR SSCertifiable Points: 5481 More actions · Answer 2

In my case, I have four servers. Two of them running SQL 2008 and the other two running SQL 2008 R2. The two running R2 are showing 80 CPU's. (which is correct) The other two running SQL 2008 one is showing 20 cpu's and the other showing 40 cpu's...??? OS is showing 80 CPU's on all four boxes.

SQLSeTTeR SSCertifiable Points: 5481 More actions · Answer 3

One more thing to note. OS = Windows 2008 Enterprise SP1

SQLSeTTeR SSCertifiable Points: 5481 More actions · Answer 4

After reading what you recommended, should I be seeing 64 cpu's on the SQL 2008 boxes? Why am I seeing 20 cpu's on one and 40 cpu's on the other? Thanks for all your help team!

Paul White SSC Guru Points: 150467 More actions · Answer 5

Brandie Tarvin (11/15/2011)
SQL Kiwi (11/15/2011)
SQL Server 2008 R2 added support for more than 64 logical processors (= schedulers).
Does this mean SQL 2008 (regular) will never show more than 64 processors?

Yes, SQL Server 2008 is limited to 64 logical processing units. SQL Server 2008 R2 is required to exceed that.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

SQL Kiwi (11/15/2011)
Brandie Tarvin (11/15/2011)
SQL Kiwi (11/15/2011)
SQL Server 2008 R2 added support for more than 64 logical processors (= schedulers).
Does this mean SQL 2008 (regular) will never show more than 64 processors?
Yes, SQL Server 2008 is limited to 64 logical processing units. SQL Server 2008 R2 is required to exceed that.

And why is he missing 88 cpus?

Paul White SSC Guru Points: 150467 More actions · Answer 7

SQLSeTTeR (11/15/2011)
After reading what you recommended, should I be seeing 64 cpu's on the SQL 2008 boxes? Why am I seeing 20 cpu's on one and 40 cpu's on the other? Thanks for all your help team!

More reading for you:

http://blogs.msdn.com/b/saponsqlserver/archive/2010/09/28/windows-2008-r2-groups-processors-sockets-cores-threads-numa-nodes-what-is-all-this.aspx

http://msdn.microsoft.com/en-us/library/aa363804.aspx

The number of processors seen by SQL Server 2008 depends on the detailed hardware/software NUMA configuration and the version/configuration of the operating system. One explanation might be that one machine has 4 NUMA nodes with 20 CPUs in each, and SQL Server 2008 is seeing just one node; perhaps the other machine is configured for 2 NUMA nodes of 40 CPUs each. Without being on site with access to all the physical details, I'm not going to be able to do much more than point you in the general direction of things to look at with your hardware/system people. Good luck.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

SQLSeTTeR SSCertifiable Points: 5481 More actions · Answer 8

Thanks Paul! Do you happen to have the white paper on that?

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 9

SQLSeTTeR (11/15/2011)
Thanks Paul! Do you happen to have the white paper on that?

Aside from the 2 he already posted and which you forgot to read?

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 10

Those are fantastic links, Paul. Thanks (even though I'm not OP).

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

SQLSeTTeR SSCertifiable Points: 5481 More actions · Answer 11

No paul, I didnt see them when I posted. Thanks again.

Paul White SSC Guru Points: 150467 More actions · Answer 12

Brandie Tarvin (11/15/2011)
Those are fantastic links, Paul. Thanks (even though I'm not OP).

You're welcome. It is a horribly confusing area. If I had more direct experience with this I'd try to be a bit more practically useful, but I don't, so I can't :laugh:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

SQLSeTTeR SSCertifiable Points: 5481 More actions · Answer 13

I just wanted to THANK everyone again. This is a great community!

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 14

You're welcome. Did you figure out what the issue was yet? I'd love to hear the details if you have them.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

SQLSeTTeR SSCertifiable Points: 5481 More actions · Answer 15

After getting the green light from my boss, I ripped out SQL 2008 yesterday and installed SQL 2008 R2. After the installation, SQL is now seeing all 80 CPU's. I just wanted to thank everyone again who contributed to this thread.