Recently I upgraded the memory in my laptop. For a few hundred dollars, I went to 16GB of RAM, which means that I can more easily run Virtual Machines without a noticeable slowdown on my system. Combining that with an SSD as a second drive, and I have laptop that I think performs well.
For servers, 16GB wouldn't be much RAM. In fact, I heard from a friend recently who had enough RAM in one of his servers that my jaw dropped open a little. I know hardware has advanced a lot in the last few years, but I wonder how much of that has filtered down to the average company.
It's time to brag a bit today, and let others drool over your SQL Server. Give us the answer to this poll question if you can.
What's the largest amount of RAM in one of your database instances?
I'm looking for the biggest box you have, and then maybe you can let us know how it's used, or how many people it supports, or some other metrics. Perhaps even tell us the database size, so we can guess what percentage is in cache.
Let us know today just how much RAM you have and how proud you are of your large instances. I'll say that 16GB is the largest server I have here at the ranch. The SQLServerCentral database servers have 24GB of RAM in their virtual machines.
Steve Jones
The Voice of the DBA Podcasts
- Windows Media Podcast - 17.0MB WMV
- iPod Video Podcast - 12.3MB MP4
- MP3 Audio Podcast - 2.9MB MP3
The podcast feeds are available at sqlservercentral.mevio.com. You can also follow Steve Jones on Twitter:
Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.
I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.