How SQL Server fills mdfs and ldf with data: Proportional fill and Round robin
Hi Guys, Welcome back! Last time we talked about the TempDB database Here . We ran some benchmarks to inspect performances variation adding one or more mdf files to the TempDB. So we have seen in which order mdf and ldf files are filled . You surely noted that we didn't say anything about how they are filled . Well we will do it now! So my friends... Enjoy reading this post i wrote (from my mobile office overlooking the Alps!!!) Simple case, one mdf file For this first simple test we create a new database named TestPF. Our dabatase will have a single mdf file. DROP DATABASE [TestPF] CREATE DATABASE [TestPF] ON ( NAME = N'PF' , FILENAME = N'E:\PF.mdf' , SIZE = 131072KB, FILEGROWTH = 131072KB) LOG ON ( NAME = N'PF_log' , FILENAME = N'E:\PF_log.ldf' , SIZE = 131072KB, FILEGROWTH = 131072KB) GO ALTER DATABASE [TestPF] SET RECOVERY SIMPLE GO Now we define a Query that return how much our mdf and ldf fil...