Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

RAMDisk and Tempdb Cahe for Tempdb

Hi Community

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?

Thanks.

Cristian Lopez.

Tags:
Former Member
Former Member replied

Hi,

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.

Tomasz Romanowski

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question