Hi What are the best settings of transaction log file and database file while installing SQL Server. I mean the size of both of the files. Should they be left on default sizes or changed? Slawek
Hi Setting the files to an initial higher size only means that the space will already be reserved upfront and the SQL server does not have to grow the file when it needs to. This means that if you always set the file size higher manually, you’ll get a slight performance increase (But only if you have a very high transaction volume).