This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - Detect Virtual Log Files (VLF) in LDF

SQL SERVER – Detect Virtual Log Files (VLF) in LDF

December 30, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, VLF

A large LDF file is made of many small Virtual Log Files (VLFs). Here is how to detect them with DBCC LOGINFO and see which ones are active.

Read More
A garden hose made of many short pieces joined by brass couplings lies coiled beside one smooth hose on a shed wall.

Monitoring Log Growth and VLF Counts

August 29, 2010
Pinal Dave
SQL Tips and Tricks
DBA, SQL Log, Transaction Log, VLF

Monitor VLF counts and transaction log growth with SQL Server DMVs, then choose file growth settings that keep recovery and maintenance predictable.

Read More
Previous 1 2
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com