February 21, 2016 at 7:03 am
Hi,
I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.
Could you please suggest if 8GB RAM and Core i5 CPU should be sufficient, or I need to go for higher config?
Azure
Visual Studio
SSMS and All Business Intelligence components (IS, AS, RS)
HDInsight
.NET Framework 4.0
APS/MPP/PDW
thank you
February 21, 2016 at 12:17 pm
etl2016 (2/21/2016)
Hi,I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.
Could you please suggest if 8GB RAM and Core i5 CPU should be sufficient, or I need to go for higher config?
Azure
Visual Studio
SSMS and All Business Intelligence components (IS, AS, RS)
HDInsight
.NET Framework 4.0
APS/MPP/PDW
thank you
As a development machine using only development tools what you showed should be fine. If you plan to run Virtual Machines so you can simulate server services (e.g. SQL Server with large databases attached and testing workloads, etc.) or experiment with closer to real world environments then I would go for more RAM and more CPU cores.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 21, 2016 at 5:09 pm
I agree with Orlando. An i5 runs fine. My laptop has been an i5, 16GB for the last year, and I run virtual machines with multiple instances of SQL and various server tools that work fine. VMs typically can run with 2-4GB if you don't need high performance.
A desktop with 8GB/i5 will be fine though you'll be limited on the nodes for HDInsight. However you'd be better off learning and experimenting with this in Azure.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 22, 2016 at 6:07 am
If you don't mind me throwing my $.02 in here, the specs sound fine, but spend a little extra money and make sure you get an SSD in it. My work issued laptop has the specs you mention (i5, 8GB memory), and I do similar tasks, however it has a traditional HDD in it, and is painfully slow to wait on when doing anything disk related when compared to any of my personal machines that have SSDs in them.
February 22, 2016 at 7:00 am
etl2016 (2/21/2016)
Hi,I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.
Could you please suggest if 8GB RAM and Core i5 CPU should be sufficient, or I need to go for higher config?
Azure
Visual Studio
SSMS and All Business Intelligence components (IS, AS, RS)
HDInsight
.NET Framework 4.0
APS/MPP/PDW
thank you
You mentioned SSMS, IS, AS, and RS would be installed on this PC, but you did not mention if there would be a locally running instance of SQL Server, and that's the biggest RAM consumer. If you want to experiment with Clustered ColumnStore or In-Memory tables, then you may want to leave 4 - 8 GB reserved just for MSSQL.
Just a few weeks back, I pulled the 4 GB RAM from my Lenovo laptop and replaced it with (2) 8 GB chips for which I paid only $72 total. With the price of 8 GB versus 16 GB being so trivial (at least for PC owners), I'd suggest starting with 16 GB regardless, for those of us who are using their PC as a development sanbbox.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 24, 2016 at 4:51 pm
With Windows 7, even the Pro edition, you have to get the x64 edition to use 16 gig, or any amount above 4 gig. Does that hold true for Win 10? I just acquired a pair of Dell 960s and would rather not have to pay for a pair of x64 licenses if upgrading to 10 Pro would do it. I've always thought this was one of Microsoft's bigger ripoffs.
That's a feature that I love about Mac OS-X: add memory and the machine sees it and uses it.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
February 24, 2016 at 4:55 pm
Orlando Colamatteo (2/21/2016)
etl2016 (2/21/2016)
Hi,I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.
Could you please suggest if 8GB RAM and Core i5 CPU should be sufficient, or I need to go for higher config?
Azure
Visual Studio
SSMS and All Business Intelligence components (IS, AS, RS)
HDInsight
.NET Framework 4.0
APS/MPP/PDW
thank you
... (e.g. SQL Server with large databases attached and testing workloads, etc.) or experiment with closer to real world environments then I would go for more RAM and more CPU cores.
Are you serious? You'll have to wait for at least a day to restore a 300GB database; what to say for 1TB.
RAM and more CPU is not saving you that much; what you need is having a good disk system.
Igor Micev,
My blog: www.igormicev.com
February 24, 2016 at 4:57 pm
Wayne West (2/24/2016)
With Windows 7, even the Pro edition, you have to get the x64 edition to use 16 gig, or any amount above 4 gig. Does that hold true for Win 10? I just acquired a pair of Dell 960s and would rather not have to pay for a pair of x64 licenses if upgrading to 10 Pro would do it. I've always thought this was one of Microsoft's bigger ripoffs.That's a feature that I love about Mac OS-X: add memory and the machine sees it and uses it.
x64 edition is required for ANY version of windows (any edition) - It's a limit of the memory address space - 32 bit cannot address more than ~3.6 GB of memory.
You may not have to, have a read here : http://www.howtogeek.com/228042/how-to-switch-from-32-bit-windows-10-to-64-bit-windows-10/
February 24, 2016 at 5:10 pm
That's the thing that I wasn't sure of, if MS was still writing their OS in a 32 bit world. Sad to learn that they're still stuck there, I guess I'll probably buy one x64 license and leave the other box at 32 for now.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
February 24, 2016 at 5:19 pm
Wayne West (2/24/2016)
That's the thing that I wasn't sure of, if MS was still writing their OS in a 32 bit world. Sad to learn that they're still stuck there, I guess I'll probably buy one x64 license and leave the other box at 32 for now.
If you read the article I linked, I don't believe you'd need to buy one.
Also, I have a machine that's just over a year old that is only capable of 32 bit - it's a 10" windows tablet, and the cpu is capable of it, but the manufacturer used a 32 bit bios, so it's 32 bit or nothing. Don't blame MS, it's a hardware limitation!
February 24, 2016 at 7:11 pm
If you're going to be running SQL Server, I'd always recommend spending an extra < $100 and bumping up the RAM. SQL Server loves memory.
Then again, what Igor said about the disk also holds true. Thinking beyond disk partitions, think about how many physical drives you want for your different content - system, data, log, etc. Granted, you can spend ridiculous amounts of money on drive setups, but don't go overboard for a home system. We can't all have a SAN at home. 😛
February 24, 2016 at 8:00 pm
Igor Micev (2/24/2016)
Orlando Colamatteo (2/21/2016)
etl2016 (2/21/2016)
Hi,I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.
Could you please suggest if 8GB RAM and Core i5 CPU should be sufficient, or I need to go for higher config?
Azure
Visual Studio
SSMS and All Business Intelligence components (IS, AS, RS)
HDInsight
.NET Framework 4.0
APS/MPP/PDW
thank you
... (e.g. SQL Server with large databases attached and testing workloads, etc.) or experiment with closer to real world environments then I would go for more RAM and more CPU cores.
Are you serious? You'll have to wait for at least a day to restore a 300GB database; what to say for 1TB.
RAM and more CPU is not saving you that much; what you need is having a good disk system.
Of course I am serious, otherwise I would nat have posted. It depends on what you need. I haven't worked on a machine with an HDD for over two years. SSD all the way.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 25, 2016 at 1:24 am
Orlando Colamatteo (2/24/2016)
Igor Micev (2/24/2016)
Orlando Colamatteo (2/21/2016)
etl2016 (2/21/2016)
Hi,I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.
Could you please suggest if 8GB RAM and Core i5 CPU should be sufficient, or I need to go for higher config?
Azure
Visual Studio
SSMS and All Business Intelligence components (IS, AS, RS)
HDInsight
.NET Framework 4.0
APS/MPP/PDW
thank you
... (e.g. SQL Server with large databases attached and testing workloads, etc.) or experiment with closer to real world environments then I would go for more RAM and more CPU cores.
Are you serious? You'll have to wait for at least a day to restore a 300GB database; what to say for 1TB.
RAM and more CPU is not saving you that much; what you need is having a good disk system.
Of course I am serious, otherwise I would nat have posted. It depends on what you need. I haven't worked on a machine with an HDD for over two years. SSD all the way.
SSD is just a fame. I don't think it will help a lot with big databases (let's say 300+ GBs as a measure for a big database). But that's the best option for a notebook, though.
Igor Micev,
My blog: www.igormicev.com
February 25, 2016 at 1:36 am
Igor Micev (2/25/2016)
Orlando Colamatteo (2/24/2016)
Igor Micev (2/24/2016)
Orlando Colamatteo (2/21/2016)
etl2016 (2/21/2016)
Hi,I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.
Could you please suggest if 8GB RAM and Core i5 CPU should be sufficient, or I need to go for higher config?
Azure
Visual Studio
SSMS and All Business Intelligence components (IS, AS, RS)
HDInsight
.NET Framework 4.0
APS/MPP/PDW
thank you
... (e.g. SQL Server with large databases attached and testing workloads, etc.) or experiment with closer to real world environments then I would go for more RAM and more CPU cores.
Are you serious? You'll have to wait for at least a day to restore a 300GB database; what to say for 1TB.
RAM and more CPU is not saving you that much; what you need is having a good disk system.
Of course I am serious, otherwise I would nat have posted. It depends on what you need. I haven't worked on a machine with an HDD for over two years. SSD all the way.
SSD is just a fame. I don't think it will help a lot with big databases (let's say 300+ GBs as a measure for a big database). But that's the best option for a notebook, though.
What do you mean by fame?
Forget the size of the database. I could have throw a query at a 1GB database and bring pretty much any machine to its knees.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 25, 2016 at 1:51 am
Orlando Colamatteo (2/25/2016)
Igor Micev (2/25/2016)
Orlando Colamatteo (2/24/2016)
Igor Micev (2/24/2016)
Orlando Colamatteo (2/21/2016)
etl2016 (2/21/2016)
Hi,I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.
Could you please suggest if 8GB RAM and Core i5 CPU should be sufficient, or I need to go for higher config?
Azure
Visual Studio
SSMS and All Business Intelligence components (IS, AS, RS)
HDInsight
.NET Framework 4.0
APS/MPP/PDW
thank you
... (e.g. SQL Server with large databases attached and testing workloads, etc.) or experiment with closer to real world environments then I would go for more RAM and more CPU cores.
Are you serious? You'll have to wait for at least a day to restore a 300GB database; what to say for 1TB.
RAM and more CPU is not saving you that much; what you need is having a good disk system.
Of course I am serious, otherwise I would nat have posted. It depends on what you need. I haven't worked on a machine with an HDD for over two years. SSD all the way.
SSD is just a fame. I don't think it will help a lot with big databases (let's say 300+ GBs as a measure for a big database). But that's the best option for a notebook, though.
What do you mean by fame?
Forget the size of the database. I could have throw a query at a 1GB database and bring pretty much any machine to its knees.
Fame - The state of being well-known and much spoken.
We had installed a SSD on a server where we have lots of updates (5K/sec) - what happened is the SSD "burnt out" for 2 months. It became bad-responsive (r/w ~ 1.5s or 1500ms) so we needed to remove it.
Igor Micev,
My blog: www.igormicev.com
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply