Re: Sparc Storage Array w/ Prestoserve NVRAM...

Greg (greg@cyberramp.net) wrote: : Has anybody put this combination to good use in an Online 7.1x : environment. I'm rattling around some ideas, but would like to hear : your success (or failure) stories. : I'd think caching writes to the physical log would produce the biggest : initial bang, but I gather it would require using cooked file space, : which i'm not crazy about. : Anyone really thought this through and want to share....??? : Greg I'm not familiar with NVRAM, but if it's a solid-state-disk or other type of memory caching device, it should help. There are two really decent articles in the current issue of Informix Systems Journal about the use of solid state disks. Basically, they say that these devices help first at the OS level, usually as swap files (if you're swapping). As database devices, using them for heavy write operations such as physical logs, logical logs, and temp space is very useful. Also, placing small, heavily-used tables and/or indexes on the SSDD will get you good results. Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) ---------------------------------------------------------------------------