I've accidentally become the dba for our team and looking at some of the databases on the server (Sql 2012), i see that all of them have been created with the default settings of 1MB Autogrowth for Data Files and 10% Autogrowth for Log Files.
I am in the process of changing those settings to something more appropriate per database. I have a question on the strategy.
For example, one of the databases has two large ETL activities per day and, looking at the history, it is growing at approx 360MB per day. The current 1MB Autogrowth is causing approx 350 autogrowth events per day. The database is currently about 26GB.
I am thinking that to reduce the constant autogrowth events, I will need to do two things: (1) Increase the current size of the database to 35 to 40 GB (about a month's worth) and (2) increase the size of the data file auto growth to 500MB to 1GB....
After that, I am planning on monitoring the growth and then manually adjusting the size as necessary. So, in one month, I would need to increase the Data File size again.
I am wondering about the impact on fragmentation too. Would it be best to just increase the size of the data file to maybe 4 or 5 months worth?
Thanks for any recommendations and guidance.