Various clustering software has functional restrictions on the transaction size and worse as the transaction size grows so does the risk of deadlocks.
My Alert Improvements spent a while rewriting alert pruning to reduce the transaction size as otherwise I was seeing deadlocks and also elevated...