Bowfinger
Lifer
- Nov 17, 2002
- 15,776
- 392
- 126
Based on the information provided, I am pretty sure it is volatile RAM (a/k/a, Solid State Disk or SSD). It may be a mirror of all or part of a database stored on conventional, magnetic disks. The RAM drives would be tremendously faster, slashing complex query times dramatically. They would be protected by a redundant UPS, almost certainly in a data center with generator backups. Should they lose the data anyway, they can easily reload from the magnetic storage.Originally posted by: Tabb
Shouldn't it be called a NVRAM Disk? I thought this was flash memory or maybe im wrong? That'd suck if they unplugged it and it really is a RAM Disk.
If this is really part of TIA, 2.5TB is only a fraction of the entire database. More likely then, the RAM drives are allocated as the database temporary storage volumes. We're looking at this for our own data warehouse, though we're only considering 400-500 GB. Placing the DBTemp space in RAM also improves performance substantially. It's nowhere near the improvement one gets by loading the whole database into RAM, however. SSD volatility is less of an issue in this scenario since the temp space is a work area with no permanent data. It would still be protected by redundant UPSs and generators, just because the whole data center is protected.
