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.

Is there any difference in performance, optimisations in MSSQL 2012 on Opteron and Xeon platform ?

basically we are thinking about 2 x 6 Cores Xeon E5-1660 or 2 x 16 cores Opteron 6380

share|improve this question

1 Answer 1

Unless you run an OLAP system the CPU is basically useless. Database servers are a LOT more likely to be limited by RAM and the disc subsystem. CPU is not a primary concern until you get REALLY big.

share|improve this answer
    
Hello TomTom. Probably we have reached the issue with the speed. Our store procedures is really big and there is billions of rows of data which is requesting each second to be extracted and processed. Currently under 2 x 4 core Xeon's we are practically holding then the whole time on 100% CPU usage, and we are on the border line and we need to decide about newer hardware. Any help would be gladly welcomed. –  Yordan Yanakiev Apr 18 '13 at 11:22
    
It really depends then. As you go for low end xeons - go with the opterons instead, but use the more expensive ones that can go into a quad processor board. Then you can upgrade another 2 procesors.... SQL Server is one of the areas I think opterons shine - the cores are slower, but there are TONS of them ;) –  TomTom Apr 18 '13 at 11:30

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.