Post reply

Need a template for capacity planning

  • August 3, 2005 at 9:43 am

    #88234

    Hi,

    Is there any document template for doing capacity planning on sql server databases?

    Thanks for your help

    -SG

  • August 3, 2005 at 11:57 am

    #579275

    Define capacity planning.  Do you mean space or performance or both?

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • August 4, 2005 at 8:56 am

    #579613

    For both. But if you know for either one of them, that is fine too.

    Thanks for the reply.

    -KG

     

  • August 4, 2005 at 9:30 am

    #579628

    Estimating the size of a database is relatively straight forward--but tedious--process.  Basically you figure out the size of each table (and indexed view) and add them up.  Books Online has a good article about how to do this under "Estimating the Size of a Table"

    Capacity planning in terms of performance is much more difficult and prone to miscalculation.  Benchmarks are seldom much use unless you can benchmark the exact software, hardware, and network configurations that you expect to run in production.  And of course, you can't do that until the system is purchased/built and in place.  This is where the experience of the vendor and/or your development team come into play.  They should know the system and hopefully have seen it in operation in various environments etc...

    I know this is pretty vague but, like I said, you can measure performance, but anticipating it is extraordinarily difficult to do with any precision.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • August 4, 2005 at 9:39 am

    #579634

    Thanks for the time and the explanation. But all I need is a tool to present this data to my higher officials so that they can buy my recommendations on hardware and software. I want them to approve the changes in hardware that I recommend without asking too many questions. That is why I was searching for some document template to present this in an attractive manner.

    I hope I made my expectations clear.  Any help is appreciated.

    Thanks.

     

     

  • August 4, 2005 at 9:44 am

    #579637

    I would speak to the vendor(s) of the hardware and software you are recommending.  They have a vested interest in helping you out with this sort of thing.  Almost every vendor I've ever dealt with has ROI calculators and comparative benchmarks to help them sell their product.

    Just make sure that they aren't blowing smoke and causing you to mislead your management...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • August 4, 2005 at 9:53 am

    #579642

    Thanks. Will try do the same.

Viewing 7 posts - 1 through 7 (of 7 total)

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