Long running SQL "Delete" operation on table "XI_AF_TREX_MSG_LOG"
We are currently facing an issue wherein a Delete
operation starts on table "XI_AF_TREX_MSG_LOG", and this in turn fills
up TLOG on the database (SQL Server) and since it was not committing,
but doing a huge long delete, it does free up space in the TLOG
during TLOG backups. Moreover, this runs for long duration
and eventually becomes Orphan process and has to be killed manually in
Does anyone know what could be trigerring this delete?