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