Interview Questions
1. What is Write Ahead Logging?
At the time a modification is made to a page in the buffer, a log record is built in the log cache recording the modification. This
log record must be written to disk before the associated dirty page is flushed from the buffer cache to disk. SQL Server has logic
that prevents a dirty page from being flushed before the associated log record. Because log records are always written ahead of
the associated data pages, the process is called a write-ahead logging.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment