Skip to content
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software
Tomas Lind
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software

Daily Archives: 2013/12/03

  1. Home>
  2. 2013>
  3. December>
  4. 3

Virtual Log File Basics

  • Post author:Tomas Lind
  • Post published:2013/12/03
  • Post category:DBCC/Transaction Log
  • Post comments:2 Comments

The SQL Server transaction log files are managed as singe files in SQL Server. But internally those files consist of several VLF’s, or Virtual Log Files.

Each time the log needs to grow, additional VLF’s are created.

Over time, if this happens a lot, there can be too many VLF’s.

(more…)

Continue ReadingVirtual Log File Basics

confided data manager

Get compliant with the GDPR!


High Coast Database Solutions

High Coast Database Solutions

sql server consulting services


Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • Line numbers in t-sql error messages
  • How to align columns in Notepad++
  • Export data from Excel to SQL Server
  • CDC Capture job
  • Moving average in T-SQL

Recent Posts

  • Get element max value from folder with XML files
  • Dynamic Data Masking (DDM) – Mask query results
  • The T-SQL Merge statement
  • From SQL Server to MSMQ using PowerShell
  • Identity columns that are about to overflow

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright - OceanWP Theme by OceanWP