Sample Header Ad - 728x90

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