Memory is straight away allocated to sap hana whenever a sap hana system starts.
The linux operating system reserves memory for various sap hana processes. Program code and program stack processes are given more or less 6 GB of memory space. That space occupation is very little comparing to other elements such as table data and computational processes.
Code and program stack memory size is normaly around 6 GB. The following query shows code and stack individual element size as well as the total size of those 2 elements.
-- Summary result on code and stack used memory for a tenant database. -- Queries executed on connected tenant database. select service_name, CODE_SIZE/(1024*1024*1024) as CODE_SIZE_GB, STACK_SIZE/(1024*1024*1024) as STACK_SIZE_GB, round( ((STACK_SIZE + CODE_SIZE) / 1024 / 1024 / 1024),3 ) as CODE_AND_STACK_SIZE_GB from M_SERVICE_MEMORY where service_name = 'indexserver' SERVICE_NAME CODE_SIZE_GB STACK_SIZE_GB CODE_AND_STACK_SIZE_GB ------------ ------------ ------------- ---------------------- indexserver 1,97 1,03 2,07 -- Database Name included to the result for "code and stack used memory". DO BEGIN DECLARE V_DBNAME varchar(20); select database_name into V_DBNAME from "SYS"."M_DATABASES"; select service_name, V_DBNAME as DB_NAME, CODE_SIZE/(1024*1024*1024) as CODE_SIZE_GB, STACK_SIZE/(1024*1024*1024) as STACK_SIZE_GB, round( ((STACK_SIZE + CODE_SIZE) / 1024 / 1024 / 1024),3 ) as CODE_AND_STACK_SIZE_GB from M_SERVICE_MEMORY where service_name = 'indexserver'; END SERVICE_NAME DB_NAME CODE_SIZE_GB STACK_SIZE_GB CODE_AND_STACK_SIZE_GB ------------ ------- ------------ ------------- ---------------------- indexserver TENDB1 1,9733 0,758853 2,732
There are only few sap hana SQL tools on the market. Sap provides 2 types of SQL management tools. Sap hana Studio SQL console is a friendly client interface software which provides the most advanced SQL capability on sap hana databases. Hdbsql is a sap hana os command line sql tool which is mainly used and integrated within unix