Lots of data in RAM

I remember buying my first computer after college. At the time I was working part time and in graduate studies part time. My aging high school era Apple II wasn't capable of handling the load, not to mention its 300baud modem wasn't a lot of fun. I could likely have gotten a faster modem with a serial connection, but most of the modern Internet providers wanted Windows or a Macintosh OS.

I decided to just spend the money and get a computer. Being a bit of a geek, I wanted to customize things a bit and get the most bang for my buck. At that time, I paged through Computer Shopper, looking for deals on parts and trying to find the cheapest 486 CPU I could. I made various choices, one of which was the RAM. I remember thinking hard at that time about whether I could get by with 2 1MB modules or did I need to go ahead and max out the motherboard and get 4. These days I think about GB, not MB, and 2 or 4 isn't a good number.

One of the first servers I built at one job was with 8MB chips, getting 32MB into a machine, which felt like a lot. Certainly more than I'd ever had in a computer before. I also remember helping write a PO for a Netware server that cost US$250,000, one with 256MB of RAM. It was the size of a washing machine and filled with 32MB HDDs, making it by far the largest machine I'd seen to date.

That's a nostalgic view back to 1992, when I was working on my CNE certification. I always think about that large, very expensive machine when I see some leap of hardware. This past week, it was a DD4 Gen-Z memory module that has 256GB of RAM in a stick. That's not only a larger scalar value than the RAM sticks I started working with, but it's an order of magnitude more memory. Imagine 4 of these sticks giving you a terabyte of RAM in a desktop. Who among us wouldn't want this for our desktop SQL Server development?

This level of tech isn't ready for most of us, but it's not that far off. 32GB laptops aren't common, but they are easy to find. You can even get 64GB of RAM now if you want to. How long before we see 128GB+ desktop and laptop machines? I have no idea, as we seem to be in a bit of a hardware lull. Most developers run 8GB or 16GB, and it seems like this has been the standard for quite a few years.

I don't know if we'll start to see some vendors pushing to add more RAM. Certainly the cloud has changed things with lots of processing and storage occurring off the local system. At this point I'd expect that three years after buying my last laptop, I'd be able to get 32GB in the same form factor for the price I paid a few years ago, but that's not the case. The machine supports 32GB, but it's pricey, the same price it was 3 years ago.

I wonder how many of you are still power hungry, wanting more powerful machines. Or has the level of performance you get from your i7 on Windows or OSX been good enough the last few years? I think this machine works great for me, whether running VMs or containers. 16GB does the job well, and I'd look to get the same level of hardware when I replace this laptop.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

Introducing the new “Teams” feature in SQL Clone. Define access to instances, images and clones for specific teams and enable devs to self-service, refreshing environments on demand.

Artificial intelligence has great potential to imp...

The O’Reilly Data Show Podcast: Alex Ratner on h...

Most insurance companies depend on human expertise...

Once we fixed this issue of bottlenecks, we ended ...

I don’t know about your experience when it comes...

In the email yesterday from the client who earlier...

The error which we observed was a failure of a rul...

I received a contact message from the “Contact u...

In our last episode, we used sp_BlitzIndex @Mode =...

Michael Drogalis announces Tutorials for Apache Ka...

Welcome back to The Ironic DBA Files, a series whe...

Up til now in the DBA Training Plan, we’ve been ...

Introduction Many times when I talk to people, the...

In the last episode, while talking about the basic...

When I was working on systems deployed in on-premi...

Sometimes you have to give people a little more ac...

eWEEK RESOURCE PAGE: The two largest cloud computi...

Microsoft has done a great job of documenting how ...

I have a client who uses MDS (Master Data Services...

Microsoft is looking to simplify its Azure Active ...

PASS Summit 2019 now has a schedule and learning t...

Thursday August 29 18.00-19.00 BST / 10.00-11.00 Pacific - Register for this Microsoft hosted webinar to learn how Redgate tools for SQL Server help deliver software quickly.

Wednesday August 21 16.00-17.00 BST/ 10.00-11.00 Central - SQL Clone enables dev, test and CI environments to be created and refreshed in seconds, on demand or through self-service, with the latest copy of production data, masked for compliance.

Wednesday September 4 14.00-19.00 BST/ 08.00-13.00 Central - Register for our free virtual learning event, to enjoy educational and entertaining sessions from Microsoft MVPs and celebrate 20 years of Redgate.

It's in the same situation, but Microsoft is takin...

A researcher abused the GDPR to get information on...

Pay for the data and store it in a blockchain-prot...

Back when I was working on a master’s degree, on...

Click to learn more about author Manan Ghadawala. ...

ETL Testing Part 2 - Operational Data Testing This...

Coming off of the heels of last week’s Flash Mem...

SMART Modular this month demonstrated one of the i...

Epyc "Rome" continues its little sibling the Ryzen...

Enterprise customers relying on Microsoft 'Bring Y...

Microsoft has a new FastTrack program for Windows ...

SQL Server 2017 suggested an index to improve perf...

After a careful investigation into their system, w...

Watch this week’s Execution Plan Operators episo...

Grey Matter Often when query tuning, I’ll try a ...

I eventually expressed them it is possible to dete...

A few weeks ago I wrote an article about the Power...

Patrick is going bananas with these different ways...

My company, Pragmatic Works, is working through a ...

In part 1 of this series – which I strongly reco...

Pre-built AI now appears in many areas of Microsof...

Phil Factor explains the correct use of the RETURN...

The second edition of The Definitive Guide to DAX ...

Aaron Bertrand announces the first update (0.9.6) ...

You may sometimes have reports or other processes ...

Outline In SQL Server 2019, a few cool performance...

Fortnite cracks, software exploits among the topic...

Last month, Attorney General William Barr gave a m...

Several high-security electronic locks are vulnera...

This privilege escalation vulnerability has lurked...

This month Microsoft patches ‘wormable’ vulner...

Boeing's response to this glaring security lapse h...

The T-SQL IN operator allows you to choose from a ...

Tables with a large amount of data can become unwi...

Steve Jones (b/t) is our host for T-SQL Tuesday an...

Itzik Ben-Gan continues a pitfall and best practic...

Recently, one of my clients showed me a very cool ...

Strange Expectations A lot of people still expect ...

Recently I wrote: Don’t store passwords in a dat...

Occasionally I’ve seen date and time stored sepa...

Tinker Toy Let’s say you have dynamic SQL that s...

Question: How to skip top N Rows in SQL Server and...

V8 variant of the Cayenne plug-in hybrid will hit ...

A California man's vanity license plate backfires ...

It’s past the middle of the year now, and every ...

After almost fifteen years of heavy usage by devel...

One of the things I needed to do recently was get ...