SQL Buffer Manager (Cache)
8K Pages between memory and disk storage
8 Pages = 1 Extent
Marking changes as “dirty” in memory and write to disk
Write ahead logging is recording of changes ‘before’ and ‘after’ each change to protect against crashes
Checkpoint default is 1-minute (recovery estimate as computed by SQL server)
Transactions:
– Atomicicity (indivisible)
– ACID test: Atomic, Consistent, Isolated, Durable
Transaction Logs can be replayed on servers to synchronize databases
9002 error is when log-file is full
Simple Recovery Model
– Logs are truncated on Checkpoint
Full Recovery Model
– Inactive Log Entries are removed/truncated as necessary to allow recovery options
Categories: