January 5, 2016 at 9:38 am
When setting up a new database what is the recommended default log file size?
January 5, 2016 at 10:06 am
thats an 'it depends' question which is dependant on size of the mdf file, throughput, recovery mode and frequency of log backups if not in simple mode.
A very rough guide is 20% of the mdf, but it needs to be able to handle the largest transaction you expect, which is usually index rebuilds.
Create it at 64MB and then grow to actual size you want it, for why see :
http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/
with reference to the link to Paul Randals addendem as this is SQL2014
---------------------------------------------------------------------
January 5, 2016 at 10:08 am
.......and just as important set the growth factor sensibly as well, do not accept the default 10%.
---------------------------------------------------------------------
January 27, 2016 at 10:23 pm
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply