Results 1 to 10 of 10
  1. #1

    Thumbs up SQL 2005 on Dual Quad or Single Quad CPU?

    we are trying to decide between dual quad or single quad cpu for our production database with MS SQL 2005.
    Can anyone comment on the performance gain between the two?

  2. #2
    Join Date
    Mar 2009
    Santa Monica, CA
    Impossible to comment intelligently without more information such as application, availability requirements, budget and cost of downtime.

  3. #3
    It's quite obvious that if you opt for Dual Quad Configuration, the performance of the server will be higher compared to single quad. However, why not study your requirements and only then select the option of the processor as there will be difference in the pricing of both.

  4. #4
    Join Date
    Jun 2009
    Seattle, WA
    The Dual will be two processors, thus it will be better.

    You need to give us some more details on your applications etc etc.

  5. #5
    Join Date
    Mar 2009
    MSSQL loves ram memory.
    keep that in mind, the CPU is not the only factor. © - Managed Hosting Solutions 2004 - 2016

  6. #6
    Join Date
    Jul 2006
    USA, EU, UK, CA, AUS
    Keep in mind your licensing cost go up with a Dual CPU. Also make sure the MSSQL version your using can address the Dual CPU's.

  7. #7
    Join Date
    Feb 2007
    USA, UK, Singapore
    Quote Originally Posted by Ultima VPS View Post
    Keep in mind your licensing cost go up with a Dual CPU. Also make sure the MSSQL version your using can address the Dual CPU's.
    Very important point to keep in mind with respect to your budgets as Microsoft product licenses are available on 'per CPU' basis. In addition to dual CPU license for SQL Server, you will also need to purchase dual CPU license for base OS. Hence, if your requirements are not much demanding, you can opt for Single Quad to reduce your licensing cost otherwise, you can opt for Dual Quad where license costs will double. For your reference, below are max number of CPU's supported by each editions of MS SQL 2005:

    Express: 1
    Workgroup: 2
    Standard: 4
    Enterprise: OS Max.


    ██ Softsys Hosting ██ - 9 Years In Business - 24/7 In-House Support - Enterprise DDoS Protection Available!

    Enterprise Dedicated Servers - WHT Exclusive Windows & Linux VPS (US/UK/Singapore) - Failover Ready Cloud VM's

  8. #8
    The database will be used for a mid size e-commerce site with two front end web servers running custom .net application with load balancer.
    We will be running MS SQL 2005 standard so it will support dual quad core.
    The site traffic will be average 60k unique visitor, 700k page views and 3k orders per day.
    As for the budget, I think we can negotiate down to be less then $800/ moth so it’s not a huge issue (we will be leasing).
    The hosting company originally quoted us single quad core for the DB server but I opt to increase to dual quad core.
    I understand there will be performance gain but I like to know how much since I can’t seem to find any bench mark data compare the two different setups for SQL.


  9. #9
    So, basically here is what you are looking at :

    2 x Web Servers ( Load-balanced ) - I would suggest Quad Core Servers with 4GB RAM or more


    1 x Database Server - I would suggest Dual Quad Core Servers with 8GB RAM or more

  10. #10
    Join Date
    May 2004
    Toronto, Canada
    We run a MUCH larger setup on lesser hardware. A config that can easily handle that is:

    2 x Web servers 2GB ram each - stop unnecessary services make it an IIS only server.
    1 x DB server single Quad 4-8gb ram. - stop unnecessary services make it a Tuned SQL server (trans and db files on separate drives, let sql optimize itself across all processors)

    Dual quad's for DB will be gross overkill for that server. The reason there is no benchmark is because it is simultaneously easy and also quite difficult to do what you are asking.

    Difficulty: Depending on the way your app is coded, caching, disk type and the strucutre of your DB including indexes, you will see different results.

    Ease: Well you have 4 additional cores which is double so you have double the processing power. The question is if your app needs it or can utilize it. If you are multithreaded you will use the available cores but you will see a ton of idle / almost idle cores all the time.

    With the dual processor setup you just doubled your licensing costs so don't do it until you need it. With the volume you quoted you really don't need it. Instead invest in fast drives.
    André Allen | E: aallen(a)
    Linovus Holdings Inc
    Shared Hosting, Reseller Hosting, VPS, Dedicated Servers & Public Cloud | USA, Canada & UK - 24x7x365 Support

Similar Threads

  1. Nothing but Xeons - Dual, Quad, Dual/Quad Quad, Dual/Quad Hex core - From $119.99/mo
    By DatabaseByDesignLLC in forum Dedicated Hosting Offers
    Replies: 1
    Last Post: 02-03-2009, 03:22 PM
  2. Replies: 20
    Last Post: 11-22-2007, 10:19 PM
  3. Replies: 4
    Last Post: 08-27-2007, 11:28 PM
  4. Replies: 2
    Last Post: 06-21-2007, 05:52 PM
  5. Replies: 5
    Last Post: 06-10-2007, 10:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts