How SQL stores data in Multiple DB files

• Jai-SQL DBA

  Ten Centuries

  Points: 1330

  More actions

  April 10, 2019 at 11:17 am

  #3088731

  Hi,

   

  Can anyone explain as how SQL server stores data in multiple DB files .Whats the algorithm and how it choses with data file to be written .

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  April 10, 2019 at 5:59 pm

  #3096063

  Jai-SQL DBA wrote:

  Hi,   Can anyone explain as how SQL server stores data in multiple DB files .Whats the algorithm and how it choses with data file to be written .

  <hr />

  It's a proportional fill algorithm based on the amount of free space in the files in the filegroup. Check the File and Filegroup Fill Strategy section in the following documentation:

  https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-files-and-filegroups?view=sql-server-2017

  Sue