Interview Questions
1. What is buffer latch?
- Buffer (BUF) latch:
The buffer latches are used to synchronize access to BUF structures and their associated database pages. The typical buffer
latching occurs during operations that require serialization on a buffer page, (during a page split or during the allocation of a
new page, for example). These latches are not held for the duration of a transaction. These are indicated in the sysprocesses
table by the PAGELATCH waittypes.
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