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

    Hi

    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.

    wingman
  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