Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
donpolix
Yak Posting Veteran
97 Posts |
 Posted - 2007-01-24 : 04:59:42
|
| From BOL:"If there are multiple files in a filegroup, they do not autogrow until all the files are full. Growth then occurs using a round-robin algorithm."..I created a test db as below:create database db1 on primary (name = 'file1', filename='c:\db1_data_1.mdf', size=1mb, filegrowth=1), (name = 'file2', filename='c:\db1_data_2.ndf', size=1mb, filegrowth=1)log on (name = 'log1', filename='c:\db1_log_1.ldf', size=1mb, filegrowth=1) ..create test table:create table db1.dbo.t1 (f1 char(500))..inserted test data:-- insert into db1.dbo.t1 select 'a'insert into db1.dbo.t1 select top 50 * from db1.dbo.t1select * from sysaltfiles where dbid=8 -- dbid=8 for db1In the beginning, after a few inserts I can see both datafiles autogrowing one after the other (round robin). But why is it all of a sudden, after a few more inserts, only the primary file alone is autogrowing? The secondary file stops autogrowing after reaching 640 pages (~5MB)??Donn Policarpio |
|
|
|
|
|
|
|
Multi datafile autogrow question