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=’
‘ />)]
i talked about this in the item below
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=15635
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=15672
]]>