November 14, 2011 at 3:29 pm
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?
Below is the query I am running:
select cpu_count from sys.dm_os_sys_info
Thank you!
November 14, 2011 at 3:30 pm
Same physical machine?
November 14, 2011 at 3:35 pm
No - Three are HP's DL580 G7's and one is a Dell PowerEdge R910.
November 14, 2011 at 3:38 pm
Hyperthreading off on the 20 cpu one?
That's as good as I can offer in that department. !
November 14, 2011 at 6:05 pm
Would this be an issue if the OS is seeing it correctly? In Task Manager I can see all 80 processors, it's just SQL that is not see them for the three aforementioned machines.
Thank you!
November 14, 2011 at 7:12 pm
Don't know, never had that issue nor read about it aside from the hyperthreading issue.
November 15, 2011 at 4:14 am
I'll disable hyper-threading tomorrow and let you know the outcome.
Thank you for your assistance!
November 15, 2011 at 4:35 am
SQLSeTTeR (11/15/2011)
I'll disable hyper-threading tomorrow and let you know the outcome.Thank you for your assistance!
No I meant maybe it's NOT activated on the 1 missing cpus. (Check Bios too).
November 15, 2011 at 4:48 am
Just to be clear, you are saying to ensure hyperthreading is active on ALL CPU's, correct?
November 15, 2011 at 5:01 am
SQLSeTTeR (11/15/2011)
Just to be clear, you are saying to ensure hyperthreading is active on ALL CPU's, correct?
Back to square 1. What is the specific problem you are trying to fix?
November 15, 2011 at 5:03 am
I want SQL server 2008 to see all 80 CPU's the same way SQL sever 2008 R2 is. My apologies if I was not clear. Thank you for your patience and help.
November 15, 2011 at 5:10 am
SQLSeTTeR (11/15/2011)
I want SQL server 2008 to see all 80 CPU's the same way SQL sever 2008 R2 is. My apologies if I was not clear. Thank you for your patience and help.
Ok, calling in some help.
November 15, 2011 at 5:33 am
A few questions:
1) How many CPUs is each box licensed for? I'm w.a.g.ging here, but I'm wondering if you're not seeing all CPUs because the license isn't set up correctly.
2) What does Server Properties -> General show for the number of processors?
November 15, 2011 at 5:46 am
Brandie Tarvin (11/15/2011)
1) How many CPUs is each box licensed for? I'm w.a.g.ging here, but I'm wondering if you're not seeing all CPUs because the license isn't set up correctly.
Licensing is a logical thing, SQL Server does not know how it is licensed. The only thing that happens if you run SQL on more processors than it's licensed for is that MS Legal slams you with one hell of a fine when they audit.
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
November 15, 2011 at 6:03 am
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). The behaviour you are seeing is likely related to the way nodes and groups are assigned. It's far too complex to get into detail here, but please read the following Microsoft CSS blog entry, and the document it contains:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 15 posts - 1 through 15 (of 30 total)
You must be logged in to reply to this topic. Login to reply