Does your application suffer from performance problems even though you followed best practices on schema design? Have you looked at your transaction log? There’s no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log, however, is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It’s as if it doesn’t matter, an afterthought, a relic of the platform architecture.
In this session, you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices. From understanding the internals we can design for faster recovery and batch processes and ironically a smaller transaction log!