Transactions and Performance | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Transactions and Performance

I’ve never quite understood how transactions affect execution time, perhaps you could enlighten me?<br /><br />Recently, I tried removing transactional markers in a stored procedure I had written. I noticed that without the transaction markers, the code performed about 40% slower. Why?<br /><br />As I understand it, a transaction requires the writing to the REDO and UNDO logs. I would have imagine this would have slowed it down. <br /><br />The only thing I can think of is that when you’re in a transaction, you don’t have the overhead of continually requesting resource locks.<br /><br />Any thoughts/links?<br /><br />[<img src=’/community/emoticons/emotion-3.gif’ alt=’:eek:‘ />)]
i talked about this in the item below