3
If you know it's going to grow 1GB per day, then yes, manually expand the file now (well, add many files and expand them all) to support as much future growth as you can afford.
Every growth event has a cost. Even with instant file initialization enabled, transactions have to wait for it to complete. If you aren't using IFI or you have extremely slow storage,...
Only top voted, non community-wiki answers of a minimum length are eligible
Related Tags
sql-server-2008 × 3858sql-server × 2334
sql-server-2008-r2 × 337
performance × 211
t-sql × 205
sql-server-2012 × 179
sql-server-2005 × 149
index × 127
replication × 110
backup × 105
stored-procedures × 95
restore × 93
database-design × 92
ssis × 84
security × 78
ssms × 70
query-performance × 66
permissions × 59
mirroring × 55
linked-server × 51
transaction-log × 49
ssrs × 44
partitioning × 38
deadlock × 38
trigger × 37