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
A single incense coil burns at one tip while its long unburned continuation remains intact

Why a Second Log File Does Not Make Anything Faster

March 20, 2012
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL DMV, Transaction Log, VLF

Adding a second log file feels like a speed fix, but it is only a spare room. Here is how to watch it work and how to retire it.

Read More
SQL SERVER - Reduce the Virtual Log Files (VLFs) from LDF file

SQL SERVER – Reduce the Virtual Log Files (VLFs) from LDF file

January 2, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, VLF

Too many virtual log files are bad for your LDF. Here is a simple script to reduce the virtual log files right away with a log backup and a shrink.

Read More
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