Simple way is to have a log table, updated nightly. Just create a table and a stored proc as below and have a job which runs it every night.

The example here runs the size query twice for two different databases on the same server. You can then have a simple report off the back of this showing the growth trends over time and on a weekly basis for the largest and the fastest growing tables.

Table:

Procedure:

 

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.