Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Virtual Memory - Database Weekly (Jan 19, 2009)

By Steve Jones,

We are all familiar with virtual memory, and in fact many of us have probably struggled with configuring page files at some point in time to ensure we had enough virtual memory. Especially with SQL Server in years past where it wanted that 4GB address space even if we didn't have that much memory installed.

We have virtualized storage with the deployment of SANS, essentially letting servers just access space without having to manage it on from the physical machine. CPUs are kind of virtualized with VMWare and other virtualization software, but memory seems like a big task to me.

I saw recently there's a company, RNA Networks,  that is looking to virtualize memory in servers, allowing it to be shared across systems. They're in stealth mode (whatever that is) and it's not clear how this works on various platforms. They list Transaction Processing as a way to use this technology and they don't seem to require a specific platform to do it on. Their partners are Sun and IBM among others, so I would think this is more of a Unix targeted solution, but I could be wrong. I haven't heard back from them at this point.

Scaling out SQL Server is something that it seems many people are interested in. And it's not for just applications that are running on 32-way boxes. There are lots of people that would love to scale up their 4-CPU system to 3 or 4 similarly sized systems rather than buying a larger machine.

I'm sure this is a technology that is still maturing and will get widely deployed at some point. Harnessing the power of multiple machines will become reality at some point and likely get used in many database systems.

Steve Jones

Steve's Pick of the Week

Business Intelligence skills are in demand - ComputerWorld surveys people every year to find out which IT skills are in demand. BI is #5. No guarantee of a job, but good that some data skills are in there.

The Voice of the DBA Podcasts


The podcast feeds are now available at to get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Incompetech. Kevin Macleod has some great compositions in all genres of music. Check him out at

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.

Total article views: 277 | Views in the last 30 days: 2
Related Articles

Virtual Memory Usage

How Does SQL Server Use Virtual Memory


New Hebrew SQL Server Podcast

Five months ago, I wrote a post about my love for Podcasts. At some point, I started to think about...





How virtual memory works at start up?

How virtual memory works at start up?





Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones