SQL Server 2008 R2 – Track Database Growth (Production Database)

Posted on

Question :

My requirement is to get the database size information collected daily, I did not find any option to get database growth over a period of time.

Someone please advise what the correct method for this could be.

Answer :

Refer the link which details as creating a table, stored procedure and a SQL Agent job to execute that sp and save details in that table everyday


  1. You can start with this Link :

  2. From this link you will get the CURRENT databases sizes.

  3. For getting the DB’s sizes per Date or Datetime, you should schedule (create a job) that run the query and insert his results into a table (new table which you should to create for this ).

  4. After all these steps you will get a table that holds per date the databases sizes .

Leave a Reply

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