Resize a new database to predicted maximum size
- by John Oxley
Currently I have a SQL Server database which is about 2 Gb. I know over the next year it's going to grow to a maximum of about 10Gb. Hard drive space is not an issue in the slightest.
Is there a down side to resizing the datafile to 20Gb now, then defragmenting the hard drive?
Should I resize the log file to 1Gb as well? Something ridiculously large so that fragmentation doesn't happen there either.
With this question I would like to avoid the datafile becoming fragmented on the disk itself, but I don't want to negatively impact performance.