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

http://sqljourney.wordpress.com/2013/02/13/sql-server-track-database-size-growth-trend/

  1. You can start with this Link :
    https://stackoverflow.com/questions/176379/determine-sql-server-database-size

  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 *