Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Would SQL server 2008 Enterprise Edition fully support Dual X5670 Processors which is equal to 24 core at total. thank you.

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

OBVIOUSLY (as per system requirements etc.) the only answer is yes.

Make sure, though, you have a LOT of memory and a LOT of IO budget (i.e. many fast discs), otherwsie in most cases most processors wil lbe idle waiting for the discs to finish.

Most of the time, CPU is like the lowest taxed area of a database server.

share|improve this answer
    
thanks for replay. i also bought 24 GB ram and 4x raid 10 sas 15k harddrives. what do you say ? –  MonsterMMORPG Dec 30 '10 at 12:52
    
Ah - realize you bought bad. Really. 24 cores - I would not go for less than 48gb ram. And seriously, if we talk discs, we should talk about a DOZEN or more. I run a quad core 8 gb virtual machine sql server. DATA is on a 6x10k RAID 10, logs and tempdb separate - and I have mostly problems getting more than 25% cpu load because the discs max out. I would say you ahve a serious problem on the disc side that will most likely make the cpu go waiting. Especially with only 24gb ram. –  TomTom Dec 30 '10 at 12:55
1  
A lot depends, though, on what you do data wise. Usage patterns trump. Olap or OLTP? Data warehouse? Small or large working set. I have seen a server max out 8 cores with 8gb ram because the active set, queried tens of thousands of times per second, was only about 4gb large (financial data). –  TomTom Dec 30 '10 at 12:56
1  
If you're running all of this on the same box, you're doing it wrong. –  mfinni Dec 30 '10 at 14:38
1  
Because you pertty much get two systems in competition to each other. 2 smaller boxes would have been better. And one for databases - with a lot of discs. –  TomTom Dec 30 '10 at 16:16
show 7 more comments

Enterprise can support up to 8 physical CPU's so yes. SQL Server supports NUMA so you should be good. From what I've heard you should also leave HT turned ON for these processors, unlike the previous recommendation which was to switch it off.

share|improve this answer
    
thanks for replay. i would give vote up but do not have enough reputation yet :D –  MonsterMMORPG Dec 30 '10 at 12:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.