SQL Server Internals: Storage Engine and Data Consistency

1. Physical Storage Architecture To the Operating System, SQL Server is simply reading and writing files. Internally, however, it manages a strict hierarchy of logical units. 1.1 File Structure Every database consists of two primary physical files lo...