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.