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 blog.sqlauthority.com 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
Please like or share this post if you found it helpful, thank you.
Share on Facebook
Facebook
0Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin
Email this to someone
email
Print this page
Print

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *