antipodes1
Active Member
In the JDE docs on SQL Server tuning, it refers to the fact that as data files grow they get fragmented. So if autogrow is set on your prod database for example, at a file level the database is fragmented each time the file autogrows. So does anyone run defrag programs over these drives containing SQL datafiles? Or do people set datafiles to be much larger than expected data size (e.g. 10Gb file for expected 6Gb of data) so that the file never autogrows or maybe jsut turn off autogrow.
cheers
cheers