Skip to content
Thursday, January 28, 2021

Ramblings of a Crafty DBA

  • Home
  • About John

Tag: Brad McGhee

Monitoring Database VLF’s

December 19, 2012October 11, 2017 admin

The transaction log file records all transactions and the database modifications made by each connection. Heavy application processing against the database can make the transaction log grow quickly. Each physical log file is divided into smaller logical units called virtual log files (VLFs). If there is no auto-growth setting on the log file, the database will stop working, be marked as suspect, when you run out of space. Therefore, it is important to monitor database file space, both data and log, so this does not happen. I will present a…

Database AdminBrad McGhee, CATCH, CURSOR, David Levy, DBCC LOGINFO, Error handling, free code, HTML Email, John F. Miner III, sp_send_dbmail, Table Variable, Transaction Log File, TRY, TSQL, Virtual Log FilesLeave a comment

Search Site

Categories

  • Database Admin (43)
  • Database Developer (81)
  • Integration Services (5)
  • Other (15)
  • Perl Scripting (7)
  • Power BI (4)
  • PowerShell (2)
  • Presentations (66)
  • SQL Tidbits (101)
  • VB Script (10)

Archives

Calendar

January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Jun    

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Crafty Dba © 2016

Proudly powered by WordPress | Theme: AcmeBlog by Acme Themes