SQL Server File Architecture: MDF, NDF, LDF, Filegroups, & Smart Autogrowth Strategy
Every database lives in files on disk. As a DBA, you need to master SQL Server's file architecture. We explain the difference between the MDF (Primary Data), LDF (Transaction Log), and NDF (Secondary Data) files. Learn how Filegroups provide flexible storage organization, and most importantly, how to implement a smart Autogrowth Strategy (using fixed MB increments) to prevent common performance spikes. We also cover the internal workings of the transaction log and Virtual Log Files (VLFs).
SQL Server File Architecture, MDF NDF LDF, Transaction Log Internals, Filegroups, Autogrowth Strategy, SQL Server storage, LDF growth, Virtual Log Files