• GilaMonster has a valid point about indexing. What are your indexs on the table and how many records does this table have? At 50 transactions/sec I would imagine a lot. It may be taking a long time to find the record to update and in the meantime another process attempts to execute the same task and begins a pile up.