Post reply

Configuring SQL Server Hardware.

  • May 15, 2002 at 7:14 am

    #58165

    How do I select the right hardware configuration like memory, disk space, number of processors etc given the number of clients, size of the database. What other factors should I consider.

  • May 15, 2002 at 7:57 am

    #429188

    There are just so many things to consider. Hard to say exaxctly what. I suggest you check thru the articles here and forums previous threads. Lots of specific questions previously. Also check out http://www.sql-server-performance.com and you hardware vendor may have some suggestion information or tools to help. Other than that tell us more about you DBs, number of clients and how the DBs are utilized. We can offer suggestions but the biggest thing is to use Performance Montior to baseline your server before production activity then give a few days and do another baseline and monitor bottlenecks like memory.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • May 15, 2002 at 8:54 pm

    #429226

    You can also try using a Server sizing tool. You can find the Compaq one here

    http://activeanswers.compaq.com/ActiveAnswers/Render/1,1027,5-6-100-225-1,00.htm

    You'll need to register to download it though.

    You put in the number of clients, required response time, etc... and it'll give you a server. From there it's just a matter of researching what is available for the type of server you require.

    Hope this helps.

    Phill

    Edited by - phillcart on 05/15/2002 8:56:17 PM

    --------------------
    Colt 45 - the original point and click interface

  • May 21, 2002 at 6:31 am

    #429522

    Thanks Phill. Compaq tool was useful, seems like Dell also has a similar tool for sizing. Just out of curiosity, how do they do this sizing ?

  • May 21, 2002 at 3:26 pm

    #429559

    quote:

    Thanks Phill. Compaq tool was useful, seems like Dell also has a similar tool for sizing. Just out of curiosity, how do they do this sizing ?

    Glad I could help.

    Not exactly sure how the mechanices of it all works. It would be something along the line of X clients * Y response time = Z cpu capacity. There is also the storage options to consider. Like if you want 2TB storage, you can have server B, but not server A. The same also goes for level of redundancy you require.

    Phill

    --------------------
    Colt 45 - the original point and click interface

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

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