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, CURRENT_TIMESTAMP) TOTAL_TIME, T.MIN_MVCC_SNAPSHOT_TIMESTAMP
FROM M_TRANSACTIONS T, M_CONNECTIONS C
WHERE T.CONNECTION_ID=C.CONNECTION_ID AND T.TRANSACTION_STATUS=’ACTIVE’ AND T.TRANSACTION_TYPE=’USER TRANSACTION’ AND T.UPDATE_TRANSACTION_ID > 0
AND SECONDS_BETWEEN(T.START_TIME, CURRENT_TIMESTAMP) > 0

Leave a Reply