title: Is there any standard tool to estimate disk space requirement for SQL Server?
body: <p>Is there a tool/application to calculate space requirement for a database in SQL Server? I know <code>sp_spaceused</code> 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.</p>
  
  <ol>
  <li>The tool should be able to connect to a SQL Server instance/database,</li>
  <li>Get data size for one row for each table</li>
  <li>User should be able to put estimated row counts for all the tables</li>
  <li>The tool should be able to estimate the size requirement</li>
  </ol>
  
  <p>With some more input like transactions per day etc, we can estimate the size of the log etc.</p>
  
  <p><strong>Update:</strong></p>
  
  <p>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</p>