Is there a tool/application to calculate space requirement for a database in SQL Server? I know sp_spaceused
can be used, but it calculates the actual space being taken up at that moment. What I was looking for is a tool that connects to the database and the user can interactively provide input like average number of rows and get the space requirement. This can be used for planning for future.
With some more input like transactions per day etc, we can estimate the size of the log etc.
Update:
I have started working on a kind of tool to meet this goal. I shall like everybody to pour in their ideas. Once it takes some shape, I am planning to put it in a open-source project site like codeplex.com
To display data and log space information for a database In Object Explorer, connect to an instance of SQL Server and then expand that instance. Expand Databases. Right-click a database, point to Reports, point to Standard Reports, and then select Disk Usage.
Below reads provide good clarity on space estimation
Estimating the Size of an SQL Server Database - http://sqlserverdiaries.com/blog/index.php/2011/05/estimating-the-size-of-an-sql-server-database/
Cindy gross checklist was very good - http://blogs.msdn.com/b/cindygross/archive/2009/03/12/previous-blogs-on-sqlcommunity-com.aspx
https://web.archive.org/web/20151026141916/http://blogs.msdn.com/b/cindygross/archive/2009/03/12/previous-blogs-on-sqlcommunity-com.aspx
How to estimate disk space needed for SQL Server - Not accessible in sqlcommunity.com.
One more link, SQL Server Sizing Resources - http://blogs.msdn.com/b/bartd/archive/2010/06/16/sql-server-sizing-resources.aspx
https://web.archive.org/web/20190421182553/https://blogs.msdn.microsoft.com/bartd/2010/06/16/sql-server-sizing-resources/
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With