Log file and database file

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).