I'm building a multi purpose development machine. I have several years experience in the IT field, but have leaned more towards networking than hardcore computer hardware.
The prospective development environment will be:
Windows Server 2012 R2
SQL Server 2014 Express (Initially before possible upgrade to Standard)
Windows 7, 8 and 8.1 virtual machines
One of the Windows virtual machines will run Visual Studio Community Edition.
The entire build is going to be for training purposes to broaden my knowledge on newer technology and software.
Server 2012 R2 is the latest MS server available commercially
SQL 2014 will be used to learn SQL
Virtual machines to learn virtual environments
Visual Studio to begin my education in programming.
The prospective build:
Preferably a non rack chassis server (it'll be installed in my house)
Dual socket (non rack chassis typically don't have dual socket)
Two quad core processors
Relevant RAM capacity
Three or more solid state drives
The goal of this build and environment is not to be bleeding edge technology or screaming powerful. I want it to have a small useful piece of several new technologies (hence the latest software choices, solid state drives, dual socket quad cores etc) so I can learn their uses, functions and failures in conjunction with one another as these are the technologies that will be replacing what I currently have experience in.
My biggest, and really only question that brought me here has to do with processor choices.
I've found a pretty consistent trend amongst my processor choices. Several of the dual core processors available for my price range have hyper-threading. As I understand it, that's 1 physical processor, two logical processors, and four possible threads. The quad core processors available for my price range don't appear to have hyper threading in most cases. As I understand it, that's 1 physical processor, four logical processors, and four possible threads.
The question is, will there be any significant advantages or disadvantages between the dual core with hyper-threading vs the quad core without hyper-threading. Keep in mind I will have two physical processors regardless of whether I choose dual or quad core.
I just read SQL Express can only utilize the lesser of one socket or four cores. That doesn't specify threads and I did recall reading SQL is hyper-thread capable but I could be wrong.
Will any of the prospective environment pieces gain or lose any major functionality or efficiency when choosing between a dual core with hyper-threading or a quad core without hyper threading.
I am partial to the quad core option. No specific reason other than they've become pretty abundant at my current company.
Answers to my specific question are all I'm after and I'd prefer responses be relevant. I'm not here to argue my path but would be open to suggest for changes that will still result in the same goal. Again, this entire build and environment is for training and educational purposes on the technology and software.
Thanks
ST
The prospective development environment will be:
Windows Server 2012 R2
SQL Server 2014 Express (Initially before possible upgrade to Standard)
Windows 7, 8 and 8.1 virtual machines
One of the Windows virtual machines will run Visual Studio Community Edition.
The entire build is going to be for training purposes to broaden my knowledge on newer technology and software.
Server 2012 R2 is the latest MS server available commercially
SQL 2014 will be used to learn SQL
Virtual machines to learn virtual environments
Visual Studio to begin my education in programming.
The prospective build:
Preferably a non rack chassis server (it'll be installed in my house)
Dual socket (non rack chassis typically don't have dual socket)
Two quad core processors
Relevant RAM capacity
Three or more solid state drives
The goal of this build and environment is not to be bleeding edge technology or screaming powerful. I want it to have a small useful piece of several new technologies (hence the latest software choices, solid state drives, dual socket quad cores etc) so I can learn their uses, functions and failures in conjunction with one another as these are the technologies that will be replacing what I currently have experience in.
My biggest, and really only question that brought me here has to do with processor choices.
I've found a pretty consistent trend amongst my processor choices. Several of the dual core processors available for my price range have hyper-threading. As I understand it, that's 1 physical processor, two logical processors, and four possible threads. The quad core processors available for my price range don't appear to have hyper threading in most cases. As I understand it, that's 1 physical processor, four logical processors, and four possible threads.
The question is, will there be any significant advantages or disadvantages between the dual core with hyper-threading vs the quad core without hyper-threading. Keep in mind I will have two physical processors regardless of whether I choose dual or quad core.
I just read SQL Express can only utilize the lesser of one socket or four cores. That doesn't specify threads and I did recall reading SQL is hyper-thread capable but I could be wrong.
Will any of the prospective environment pieces gain or lose any major functionality or efficiency when choosing between a dual core with hyper-threading or a quad core without hyper threading.
I am partial to the quad core option. No specific reason other than they've become pretty abundant at my current company.
Answers to my specific question are all I'm after and I'd prefer responses be relevant. I'm not here to argue my path but would be open to suggest for changes that will still result in the same goal. Again, this entire build and environment is for training and educational purposes on the technology and software.
Thanks
ST