Troubleshooting High Memory consumption in SAP HANA

[Indian-ktmv]

nicely u have explained... plz share few other troublshoot issue system slowness and cpu etc related

[mohdimran-kpvr]

Can interviewer ask about a SQL statement. Because this statement is too lengthy

[kingfaguam]

select CONNECTION_ID, TRANSACTION_ID, SCHEMA_NAME, DB_USER, APP_USER, STATEMENT_START_TIME, CPU_TIME,
as as MEMORY_SIZE_GB,
STATEMENT_STRING, RECORDS, OPERATION, APPLICATION_SOURCE, OBJECT_NAME, PARAMETERS, WORKLOAD_CLASS_NAME,
STATEMENT_THREAD_LIMIT, STATEMENT_MEMORY_LIMIT, APPLICATION_NAME
from
where order by MEMORY_SIZE DESC;