Buffer Cache

Query to view buffer cache size:

SELECT VOLUME_ID as "Volume ID",
ROUND(MAX_SIZE/1024/1024/1024,3) AS "Max Buffer Size in GB"
FROM SYS.M_BUFFER_CACHE_STATISTICS​

Update buffer cache size:

‘max_size_rel’: This is a relative parameter like 10%, 15% of total HANA memory. ‘max_size’: This is the exact size in GBs like 500,1000 etc.

ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'system') 
SET ('buffer_cache_cs','max_size_rel') = '10' WITH reconfigure;

Buffer cache ratio with NSE storage is normally 1:8 i.e. Buffer size should be at least 12.5% of the total size of NSE storage space.

Monitor Buffer Cache: