Tempdb in RAM? How about your entire server?

Cool. But want real performance? Get one of these…

I saw a blog by Paul Nielsen today on putting tempdb in ram via the software ram download called RamDisk. Actually this is pretty cool!  I’ve never seen it before, but it looks like something i’d like to geek with. Essentially it makes a virtual RAM disk, which you can then move whatever you want (files, tempdb, etc.) over to, and thus allowing you to “pin” your entire database in RAM. It’s made by DataRam, and might be sort of fun to dork with for sure.  You can catch Paul’s blog at http://sqlblog.com/blogs/paul_nielsen/archive/2010/02/15/tempdb-in-ram.aspx.

However, if you really want something fast, get a HyperDrive5 from http://www.hyperossystems.  These little gems allow you to plug in a drive that’s nothing but RAM; talk about fast, this will put any software RAM application in the dirt!  We deployed something similar to one of these back in 1998-1999 or so at www.Match.com, and it worked really well.  Check out the stats that the manufacturer boasts – speed deluxe!  And best of all, check out that price.  “Dirt” cheap as well, depending on how much RAM you throw in there, of course.

Lee

----------------------

64 GB RAM at the house. Just what I wanted!