What Are Log Buffers and How Do Log Flushes Work?

Senior MS SQL

Answer

Changes go to an in-memory log buffer. A log flush occurs:

  • On transaction commit
  • When buffer fills
  • On checkpoint

Slow log storage = slow commits.

Want to bookmark, take notes, or join discussions?

Sign in to access all features and personalize your learning experience.

Sign In Create Account

Source: SugharaIQ

Ready to level up? Start Practice