Priority Transactions

Performance → Core Performance

If a transaction does not commit or roll back for a long time while holding row locks, it can potentially block other high-priority transactions. This feature allows applications to assign priorities to transactions and for administrators to set timeouts for each priority. The database will automatically roll back a lower priority transaction and release the row locks held if it blocks a higher priority transaction beyond the set timeout, allowing the higher priority transaction to proceed.

Business Benefit: Priority Transactions reduces the administrative burden while also helping to maintain transaction latencies and SLAs on higher priority transactions.