Sap hana code and stack used memory detail analysis

--  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