Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is there any standard tool to estimate disk space requirement for SQL Server? Expand / Collapse
Author
Message
Posted Monday, July 4, 2011 5:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 3, 2013 10:42 PM
Points: 1, Visits: 12
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.

The tool should be able to connect to a SQL Server instance/database,
Get data size for one row for each table
User should be able to put estimated row counts for all the tables
The tool should be able to estimate the size requirement

With some more input like transactions per day etc, we can estimate the size of the log etc.


You can see this here too:

http://stackoverflow.com/questions/6264827/is-there-any-standard-tool-to-estimate-disk-space-requirement-for-sql-server
Post #1135861
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse