Earlier this year I was sent an interesting question about why the person was seeing lots of VLFs in the log with status = 2 (which means active) after clearing (also known as truncating) the log and log_reuse_wait_desc showed NOTHING. I did some digging around and all I could find was an old blog post from 2013 [&]

The post Lazy log truncation or why VLFs might stay at status 2 after log clearing appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/_aq8L-YV_-g/