Would SQL server 2008 Enterprise Edition fully support Dual X5670 Processors which is equal to 24 core at total. thank you.
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.
|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.