RAMDisk and Tempdb Cahe for Tempdb
I have OS AIX 7.1 with ASE 15.5 and set up RAMDisk for tempdb, but I don´t know if is necessary drop or leave the tempdb cache. What is the better configuration?
Tomasz Romanowski replied
Marcin is right.
Beter is to have bigger cache than use memory space for ramdisk.
Even if you use ramdisk for tempdb still ASE thinks that devices are located on hard disk and still ASE needs a cache to read any page from tempdb. In that case you need use RAM for RAMDISK and for cache for tempdb pages.
From my practice if you create cache as big as tempdb it will be enough.
Exception is when you use in-mememory database. In that case ASE knows that all is in RAM so it does not need double caching.