SQL Server Performance

Dual core with 2 cpu vs quad core with 1 CPU

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by WingSzeto, Jan 22, 2007.

  1. WingSzeto Member


    We are currently planning to buy a new Dell server for SQL 2005 to host our transactional datbases and are debating whether we should use a dual core with a 2-CPU server or a quad core with 1-CPU server. What are the advantages or disadvantages with each?

    Any input on this is very much appreciated.

  2. joechang New Member

  3. bradmcgehee New Member

    Currently, from a licensing standpoint, it is less expensive to user fewer sockets and more cores, as current SQL Server licensing is based on sockets, not cores. This might change in the future.

    Brad M. McGehee, SQL Server MVP

Share This Page