SQL Server – Application to Determine Database Growth and Cost

database-projectssql serversql-server-2008-r2

I am using SQL Server 2008 for product development

Currently application is live with 20 users now if I want to check how my database is growing and how much it will grow in month or year projection to determine the cost of hardware. Is there any application or SQL Server built-in function?

Using SQL Server profiler I am able to monitor database queries and fine tuning.

Best Answer

  1. You can use a third party tool Idera Diagnostic Manager to identify the growth and cost. There is a report inbuilt which forecast database and table growth depending upon how much historical data it has.

  2. You can also set up this with the help of combination of TSQL + Powershell as described Database Space Capacity Planning by chad. It will help you in analyzing the database growth.

  3. You can also see the Brent Ozar's answer on this as a solution as well

Estimate projected database growth