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
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.
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.
You can also see the Brent Ozar's answer on this as a solution as well
Estimate projected database growth