Transaction Log Internals: Virtual Log Files
Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up into smaller segments known as Virtual Log Files, or VLFs. Having too many VLFs will cause performance to suffer. And having too few will cause backup performance to suffer. How do you strike the right balance? In this more advanced session, veteran DBA Mike Hillwig will dig into the transaction log and show you what VLFs are, how they're created, how to identify them, and how to strike the right balance between too few and too many.
Sorry, there are no downloads available for this session.
Native Pittsburgher and Boston resident Mike Hillwig is a senior SQL DBA for a global financial institution. He's been working with SQL Server since version 7. He's got a background in infrastructure and networking. In his current role, Mike's portfolio of SQL servers grows weekly, sometimes daily. He's quite passionate about automating administrative tasks.Mike has been a SQL Server MVP since October 2014.
The video is not available to view online.