Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: 282 | 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...

BLOG

SQL Server Radio – Virtualization and Independent Consulting

I recently recorded a podcast with the SQL Server Radio group and discussed virtualization, high ava...

FORUM

memory

memory

FORUM

How virtual memory works at start up?

How virtual memory works at start up?

Tags
 
Contribute