Is it somehow possible to predict / foresee when SQL Server will trigger auto-growth?

I found numerous questions / answers about SQL-Server auto-growth - almost all indicating that one should try to avoid auto-growth if possible.

However auto-growth is available with MS SQL Server and sometimes required.

Is there any way how one could predict when SQL Server will trigger it's next auto-growth event or is this calculation completely internal to SQL Server?

(E.g. is there some kind of "fill-level" in settings which SQL Server compares to the current database usage and then triggers auto-growth when this fill-level will be reached?)

BR
Mark

I think the best way is to go based off of previous events, and one way to do that is to use a trace to start capturing history.

• https://sqlblog.org/2007/01/11/reviewing-autogrow-events-from-the-default-trace

Also some ideas here:

-
https://serverfault.com/questions/33329/how-can-i-get-alerted-when-auto-growth-occurs-on-a-sql-server-database

-
http://www.sqlservercentral.com/articles/autogrowth/93229/

As you can see, there are many ways to approach this. Let me know what you think.

StackExchange Database Administrators Q#64213, answer score: 2