Post reply

Is there a tool or method for determining disk space for new database server?

  • December 14, 2006 at 8:35 am

    #122071

    We are planning a new web server and database and want to know how to calculate and plan for disk space requirements for the database and logs. 

     

    We are planning on a disk array for database and a seperate one for logs.  Is there a formula for figuring out how much log space will be needed if we know the database size?

    Thank you for any assistance you can give.

    New to the DBA world...thank you for your help!,

    IanR

  • December 14, 2006 at 8:55 am

    #678112

    Ian

    There are scripts you can search for on this site for estimating table and database size.

    As for log space, this depends less on the size of the database than on what it actually does.  An OLTP database will need a much larger transaction log than an OLAP database, for example, and if you need to take account of activities such as reindexing and bulk inserts, which can use a lot of log space in a short time.

    Hope that helps

    John

  • December 14, 2006 at 10:03 am

    #678135

    you have to look at your data types in columns and the number off rows you expect. Once you get this number, double or triple it to get some breathing room in case you run out of space

  • December 14, 2006 at 10:08 am

    #678136

    Thank you!  I looked up some articles on the site and found a few things.  I guess without some kind of baseline its hard to tell. 

    New to the DBA world...thank you for your help!,

    IanR

  • December 14, 2006 at 11:18 am

    #678159

    And also you should know database activity...

    It depends on the data inserted into your db...

    If you want spend money there is tool from Quest which provides Trend Analysis...

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply