What value should be set for the MSSQL database in the autogrowth parameter?

Question

SQL Server

In my case, SQL Server 2014
Too large autogrowth will lead, as far as I understand, to a larger size of the database files.
How to determine what value for autogrowth to set? Is it possible to somehow see the statistics on how much earlier the database grew during transactions? Let's say a 8GB database grows steadily with transactions by 10MB. Where can I see the value of 10MB in history in order to change the standard 1MB to a larger value, but optimal for this database?

Answer 1

1. Read https://sqljana.wordpress.com/2018/08/03/sql-serve... and see how many times and when autogrow was called.
2. Record the size of the base and see how much it will grow in a day, week, month.
3. Determine how important it is for you if the base size grows by 3-4 monthly increments. Does it matter to you that the space will be occupied?
4. Is it possible that the base growth is performed during operation? If not, then you will have to write your own script to increase the size and run it at the moments of the least load on the database.
Collect the answers and you can decide for yourself whether or not to enable autogrow and what size to set. For example, I had autogrow within a 2-3 week increase in the size of the base.