
I recently stumbled on a great article by Paul S. Randal. He summarizes well what can be done to optimize transaction log performance. You can read his full post here.
This post is my follow up on his post. Using examples we'll take closer look at a transaction log and WRITELOG bottleneck. Latter part of the post examines ways to optimize a system suffering from slow transaction log. But first we recap the problem we are trying to solve.
Transaction log bottleneck
Consider an OLTP system that is doing inserts in somewhat constant rate. For some...