Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)
Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] large object (LOB) data 2nd 3rd latches vs. locks Lightweight Pooling configuration option 2nd load_factor column LOB (large object) data 2nd 3rd Locale column lock blocks lock compatibility lock duration lock escalation lock hints lock modes bulk update locks 2nd conversion locks exclusive locks 2nd intent locks 2nd key-range locks overview schema modification locks schema stability locks shared locks 2nd update locks 2nd lock owner blocks lock ownership lock partitioning lock resources LOCK_TIMEOUT option locking [See also concurrency] ALLOCATION_UNIT locks application locks associated entity ID bound connections bulk update locks 2nd controlling conversion locks data modifications in indexes databases deadlocks examples exclusive locks 2nd extents granularity HOBT locks intent locks 2nd internal architecture key-range locks 2nd latches vs. locks lock blocks lock compatibility lock duration lock escalation lock hints lock modes lock owner blocks lock ownership lock partitioning lock resources lock types for user data LOCK_TIMEOUT option Multiple Active Result Sets (MARS) number of slots in hash table overview 2nd row versioning [See row versioning] row-level vs. page-level schema modification locks schema stability locks shared locks 2nd spinlocks sys.dm_tran_locks view syslockinfo table timeouts update locks 2nd viewing locks Locks configuration option 2nd log backups log files backing up databases [See backing up databases] changes in log size [See changes in log size] log sequence numbers (LSNs) overview 2nd reading logs recovery phases restoring databases [See restoring databases] transaction log basics log sequence numbers (LSNs) log size changes active VLFs automatic shrinking automatic truncation of VLFs log file size maintaining recoverable logs multiple physical log files observing VLFs overview recoverable VLFs reusable VLFs unused VLFs VLF overview VLF states logging analysis recovery phase backing up databases [See backing up databases] Buffer Manager fast recovery index data modifications log sequence numbers (LSNs) log size changes [See log size changes] optimizations in tempdb database overview phases of recovery reading logs redo recovery phase restart recovery restore recovery restoring databases [See restoring databases] transaction log basics undo recovery phase write-ahead lost updates LSNs (log sequence numbers) |