How to find database growth size in sql server

All of a sudden I received an email from the database owner –

“pls share file growth if u have so that the sizing can be done better”

We don’t have any mechanism or 3rd party tool that monitored such historical data. Also, no trace was enabled previously on the server. I started searching on internet for a quick way to find the growth size set for all the databases on a SQL instance. Thanks to I got my solution with two TSQL scripts that end up my search.

Here is the TSQL script

Here is the result

Here is another TSQL script 

Here is the result 

If you want to Calculate database size ‘Growth Rates’ on daily basis in SQL Server here is another post.

Facebook Comments Box


Leave a Reply

Your email address will not be published.