SQL 2012 Features VLF Warnings

I’ve finally had a chance to play around with SQL Server 2012 and one of the nice things I’ve discovered is that it features a warning when a transaction log file has an excessive number of virtual log files. I’ve written about VLFs before and any seasoned DBA will know about them. However, there are […]

The Mystery Of The Model Database Transaction Log Growth

I had to play detective a bit this week. I get a weekly report that gives me a list of databases that have more than 50 VLFs in their transaction log files. I posted the code that generates it here. My transaction logs are in pretty good shape now and I only occasionally get a […]