proportional fill

• winston Smith

  SSCoach

  Points: 19500

  More actions

  February 20, 2009 at 4:15 am

  #155303

  In sql server 2005, im aware that sql will use proportional fill to split out the usage of db files equally between two files, if they are roughly the same size.

  does this apply to log files or is it just data files it applies to?

• John.Sansom

  SSCertifiable

  Points: 7335

  More actions

  February 20, 2009 at 4:19 am

  #947405

  Yes, this also applies to log files.

  The point to understand here is that the proportional fill only applies to files within the same Filegroup.

  You may find the following reference useful reading.

  http://msdn.microsoft.com/en-us/library/ms187087.aspx

  Cheers,

  ---

  John Sansom (@sqlBrit) | www.johnsansom.com