Home / server / Questions / 217377
Accepted
MonsterMMORPG
Asked: 2010-12-31 04:31:57 +0800 CST

SQL server 2008 Enterprise Edition - Dual X5670 Processors Support

  • 772

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

sql-server sql

2 Answers

  1. 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.

    • 3
  2. Best Answer

    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.

    • 2