Post reply

Capacity Planning

  • May 25, 2012 at 5:24 am

    #274443

    good Day. We were used to build an sql server and space is never an issue , but lately this bubble has burst and I would like to know if there is a reliable method to estimate database growth and future estimates . Any ideas ?

  • May 25, 2012 at 5:35 am

    #1493070

    Historical trends and extrapolation can get you a reasonable idea. Otherwise chat with business and see how they see business expanding over time and use that along with your knowledge of what you store to work out how the sizes may change.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 25, 2012 at 5:35 am

    #1493071

    This should get you on the right track:

    http://msdn.microsoft.com/en-us/library/ms187445.aspx

    -- Gianluca Sartori

  • May 25, 2012 at 5:59 am

    #1493082

    Have you been monitoring and recording disk space utilization for the past duration of time? If so, you can use this as trend analysis and see where that is going. A faily accurate method, and probably your best bet.


    Twitter: @SQLife
    Email: sqlsalt(at)outlook(dot)com

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

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