{"id":1031,"date":"2014-09-09T13:47:56","date_gmt":"2014-09-09T13:47:56","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=1031"},"modified":"2024-01-06T16:44:49","modified_gmt":"2024-01-06T16:44:49","slug":"sep-2014-what-the-vlf-mike-hillwig","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=1031","title":{"rendered":"Sep-2014 ~ What the VLF? ~ Mike Hillwig"},"content":{"rendered":"<p><a href=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/03\/Mike-Hillwig.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-thumbnail wp-image-453\" title=\"Mike Hillwig\" src=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/03\/Mike-Hillwig-150x150.jpg\" alt=\"\" width=\"150\" height=\"150\" \/><\/a><\/p>\n<p><span style=\"color: #800000;\">Presenter:<\/span> Mike Hillwig<br \/>\n<span style=\"color: #800000;\">Topic:<\/span> What the VLF?<br \/>\n<span style=\"color: #800000;\">Downloads:<\/span> <a href=\"http:\/\/mikehillwig.com\/2013\/05\/10\/what-the-vlf\/\">Available at CrankyDBA.com<\/a><\/p>\n<p>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. <\/p>\n<p>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 show you what VLFs are, how they\u2019re created, how to identify them, and how to strike the right balance between too few and too many.<\/p>\n<p><span style=\"color: #800000;\">Biography:<\/span><\/p>\n<p>Native Pittsburgher and Boston resident Mike Hillwig is a senior SQL Server DBA for a provider of private cloud-based solutions for the financial industry He&#8217;s been working with SQL Server since version 7 and has a background in infrastructure and networking.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Presenter: Mike Hillwig Topic: What the VLF? Downloads: Available at CrankyDBA.com 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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[184],"tags":[178,176,177],"class_list":["post-1031","post","type-post","status-publish","format-standard","hentry","category-2014-events","tag-database-administration","tag-transaction-log","tag-vlfs"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/1031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1031"}],"version-history":[{"count":7,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/1031\/revisions"}],"predecessor-version":[{"id":1118,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/1031\/revisions\/1118"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}