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

Incompetech

The podcast feeds are now available at sqlservercentral.podshow.com 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 www.incompetech.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.

Total article views: 273 | Views in the last 30 days: 1
 
Related Articles
FORUM

Virtual Memory Usage

How Does SQL Server Use Virtual Memory

BLOG

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...

FORUM

memory

memory

FORUM

virtualization

virtualization

FORUM

How virtual memory works at start up?

How virtual memory works at start up?

Tags
 
Contribute

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
Editor, SQLServerCentral.com

Already a member? Jump in:

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