I want to change it to growth 10% each time.In my opinion that is most likely not tthe smartest thing to do as the practices/recommendations are actually to change the default 10% growth to a MB value as you have it already set even if you have Instant File Initialization turned on because your performance may suffer and potentially significantly and that depends on how good your IO subsystem handles the writes.
If you're talking about Auto_Grow settings, then I would choose a number that is large enough so that you can react to it but small enough that it won't impact users and won't continue to auto_grow in multiple cycles. Ideally the amount of free space a database has will allow it to run for whatever your company standard is. For example if all databases needed to have at least 3 months of space available, then you might want manually grow the files so that it has the 3 months and set the auto_grow to some smaller number, say 3 days in case of an emergency.More good advice/best practice can be found here as well: https://docs.microsoft.com/en-us/previous-versions/technet-magazine/cc671165(v=msdn.10)?redirectedfrom=MSDN
because your performance may suffer and potentially significantly and that depends on how good your IO subsystem handles the write
tthe smartest thing to do as the practices/recommendations are actually to
Related to the Publisher where you did changed it already...maybe you should review-reconsider to grow it periodically as mentioned
Also added a maintenace plan to shrink the databases and their logs every evening.people here suggest do not do this , just backup the log with truncate.
why change to MB is good ? I don't want it to keep growing ! growth rate like 1MB each time is not good!From the screenshot you posted above the growth is not 1MB but 1000MB = 1GB and why change to MB I provided few links that explains in detail why and how. Just think that you can't apply the same growth rate to ALL servers ALL db's like bread and butter just because the obvious reasons as explained in detail at those links - simply put each grows at its own pace depending on the OLTP it takes.
simply put each grows at its own pace depending on the OLTP it takes.
you can't apply the same growth rate to ALL servers ALL db's like bread and butter just