Which is better -- Dual Xeon or Latest iX CPUs?

certhelpcerthelp Member Posts: 191
in Off-Topic
I noticed that used dual xeon workstations are listed for ~$400 while desktops with single i7 (not newer sandy bridge) ~$500. But the xeon CPU computers take ECC DDR2 RAM and i7 take cheaper DDR3 non-ECC RAM.

In terms of CPU performance (of course for running VMs) which is better -- single i7 or dual xeon?
· Share on FacebookShare on Twitter

Comments

  • RobertKaucherRobertKaucher Member Posts: 4,299 ■■■■■■■■■■
    Is this lab or prod? For a home lab the i7 systems would be just fine. For production I have a few concerns such as not being able to use ECC and I have heard that hyper threading has caused some odd issues with SQL Server. I would not use i7 in production at this point.
    · Share on FacebookShare on Twitter
  • certhelpcerthelp Member Posts: 191
    RobertKaucher wrote: »
    Is this lab or prod? For a home lab the i7 systems would be just fine. For production I have a few concerns such as not being able to use ECC and I have heard that hyper threading has caused some odd issues with SQL Server. I would not use i7 in production at this point.

    Non production workstation for home lab use. Why specifically SQL Server has problems with i7?

    I am not really looking for a bleeding edge solution. I seriously doubt any learning db I use would be larger than a few GBs.

    My intention is to to run 8+ VMs for Windows 2008 Server, SCCM, SQL Server, Exchange, Windows Desktop clients (win7, vista), etc.
    · Share on FacebookShare on Twitter
  • RobertKaucherRobertKaucher Member Posts: 4,299 ■■■■■■■■■■
    certhelp wrote: »
    Non production workstation for home lab use. Why specifically SQL Server has problems with i7?

    I am not really looking for a bleeding edge solution. I seriously doubt any learning db I use would be larger than a few GBs.

    My intention is to to run 8+ VMs for Windows 2008 Server, SCCM, SQL Server, Exchange, Windows Desktop clients (win7, vista), etc.

    Be aware: To Hyper or not to Hyper - Slava Oks's WebLog - Site Home - MSDN Blogs

    I do not know if this is true with modern versions of SQL Server. it is not a problem with i7 specifically, it is an issue with hyper threading.
    · Share on FacebookShare on Twitter
  • Asif DaslAsif Dasl Member Posts: 2,116 ■■■■■■■■□□
    You can compare processors using this website. I would go with a second generation i7 if I was going to run VMs in a home lab, especially as they run cheaper non-ECC RAM.
    You can tell whether a man is clever by his answers. You can tell whether a man is wise by his questions. - Naguib Mahfouz

    The mind is the limit. As long as the mind can envision the fact that you can do something, you can do it, as long as you really believe 100 percent. - Arnold Schwarzenegger
    · Share on FacebookShare on Twitter
  • RobertKaucherRobertKaucher Member Posts: 4,299 ■■■■■■■■■■
    Asif Dasl wrote: »
    You can compare processors using this website. I would go with a second generation i7 if I was going to run VMs in a home lab, especially as they run cheaper non-ECC RAM.
    Agreed! For home las cheaper is generally better!
    · Share on FacebookShare on Twitter
  • certhelpcerthelp Member Posts: 191
    RobertKaucher wrote: »
    I do not know if this is true with modern versions of SQL Server. it is not a problem with i7 specifically, it is an issue with hyper threading.

    So, that doesn't favor any particular family of processors but those with or without HT. Since HT can be enabled/disabled, it isn't a real problem.
    · Share on FacebookShare on Twitter
  • RobertKaucherRobertKaucher Member Posts: 4,299 ■■■■■■■■■■
    certhelp wrote: »
    So, that doesn't favor any particular family of processors but those with or without HT. Since HT can be enabled/disabled, it isn't a real problem.

    Exactly. And I suspect it msy no longer be a problem. For labbing using HT would not be an issue at all.
    · Share on FacebookShare on Twitter
Sign In or Register to comment.