Weekly Dynamic: Why Won’t the SQL Transaction Log Clear?

In the past we’ve looked at the SQL transaction log

• To Find Databases Where the Log is Too Big
• To find out Why the Transaction Log is Full
• To Monitor the Transaction Log for Unusual Growth

This week, courtesy of the illustrious Paul Randal, we have a SQL Script to help figure out why the log can’t clear. The script is

select log_reuse_wait_desc from sys.databases

and you get back results like this: