SQL Server Log Architecture

SQL Server Log Architecture

The log file is not just that stores information, this is mainly responsible for data consistency. This file stores all the transactions that modify/add data in the database.        Log files has VLF (Virtual Log Files) in it instead of pages unlike data files. VLF’s may not be of the same size, we can manually change ...
SQL Server Page Architecture

SQL Server Page Architecture

The page is the basic building block of storage in SQL server. Data is stored in datafiles (.mdf and .ndf).  Storages are built by group of pages, logically speaking data is stored in pages. Each page is of 8 KB (8192 bytes) in size, unlike the page/block size in filesystems, SQL server cannot change the ...
SQL Server Database Architecture

SQL Server Database Architecture

SQL Server database is a logical collection of data. In SQL Server, data is stored in two set of files, Data files and Log files. When we create a database there are two files created for every database that is the Data File (.mdf) and Log File(.ldf) and a Primary filegroup (a container) is created ...
Close Menu