Category: Hana Administration

SAP HANA – How to check long uncommitted write transactions

Long uncommitted write transaction possibly incurs performance degratation. You can find a long uncommitted write transaction by the following query. SELECT T.HOST, T.PORT, C.LOGICAL_CONNECTION_ID, C.CLIENT_HOST, C.CLIENT_PID, T.TRANSACTION_ID, T.UPDATE_TRANSACTION_ID, SECONDS_BETWEEN(T.START_TIME, …