SQL Server Overview

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)
– 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

Leave a Reply

Your email address will not be published. Required fields are marked *