Paul S Randal: Transaction Log Performance



Paul S Randal: Transaction Log Performance

Paul S Randal: Transaction Log Performance

One of the most misunderstood parts of SQL Server is its logging mechanism. The fact that the transaction log exists and can cause problems if not managed correctly seems to confound many DBAs and developers. Why is it possible for the transaction log to grow unbounded? How can transaction log performance be monitored and improved? Why does it take so long for operations involving the log? In this in-depth session Paul will discuss the performance issues that can be caused by the transaction log and what you can do to detect and alleviate them.

Supplementary materials can be found here:
http://globalhebrew.sqlpass.org/Home.aspx?EventID=2180