Sql Server - Best Practices for Growing Large Database Files
1
vote
1
answer
3391
views
I know this kind of question has been asked previously but I don't get the answer that I'm looking for.
I'm reconsidering setting up Autogrowth for DB Primary & Data files for Log(partitioned table) and Log Files. I am going through some articles and what I conclude is:
Microsoft is suggesting ***Autogrowth to 1/8th of file size which is 12.5%*** on another hand Brent Ozar and others are suggesting ***256MB for data files and 128MB for log files***.
Now, I'm confused as my main database file is approximate 545GB and Logfile is around 330GB, and there will be big difference (either too big or too small) if I chose any option.
Currently, Autogrowth is set to 500MB for main data file, Logfile is set to 10% and for other NDF files Autogrowth is set to 5MB and 64MB
What would you recommend and how can I calculate it?
Asked by Hakoo Desai
(111 rep)
Jul 10, 2023, 02:33 AM
Last activity: Apr 13, 2025, 12:02 AM
Last activity: Apr 13, 2025, 12:02 AM