Platinum Sponsor

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.
Presented by Mike Hillwig at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Mike_Hillwig.jpg
    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.
    http://mikehillwig.com
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.