Most DBAs Don’t Seem to Know that Transaction Logs Can be Tuned

image

I was very surprised to see the results of my latest poll, which asked “When was the last time you tuned your transaction logs?”

According to those DBAs who responded to the poll, about 60% of them said they didn’t know transaction logs could be tuned. And just over 19% said they have never tuned their transaction logs. Sadly, only about 21% said they have tuned their transaction logs in the past.

If you are one of those DBAs who don’t know transaction logs can be tuned, you need to take the time as soon as possible to learn about this topic.Why? First, every data modification made in SQL Server must be logged. Second, no transaction can complete until all of the related data modification are written to the transaction log. And third, writing to a transaction log is a single thread process. On a busy SQL Server instance, writing to the transaction log can become a bottleneck, preventing transactions from being completed on a timely basis, slowing down the entire instance.

There are many ways to tune a transaction log, some very simple, and others slightly more complicated, but it is not beyond the ability of most DBAs. To learn more about transaction log performance tuning, download my presentation slides on “Inside the SQL Server Transaction Log”, which will give you a good start on learning the basics of this important topic.

About these ads

8 thoughts on “Most DBAs Don’t Seem to Know that Transaction Logs Can be Tuned

  1. Thank for the clear and very understandable details about the lifecycle of a Sql Server log file.
    It is rare to see such a complex subject explained in such a helpful manner.

  2. Um, probably a stupid question, but how can you tell if the transaction logs are being tuned or not?

  3. Randall, download the presentation mentioned in my post, and if what I describe has not been done, then your transaction logs have not been tuned.

  4. Amazing presentation with very detailed information about the log internals explained in a directly-to-the-point way!
    Thank you for the dedication in writing it.

    Best regards,

    Andre Guerreiro Neto

  5. Pingback: Why Tune Your SQL Server Log? – Mentora Group

  6. The topic of transaction log tuning has been explained so brilliantly. Excellent work, Brad. Thanks for benefiting the SQL Server community with your wealth of knowledge.

Comments are closed.