Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2007
    Posts
    2,050

    Recommended hardware configuration

    Hello,

    One of my customers wants to host around 400 websites on a dedicated server which will have SQL 2000 Standard Edition installed and 400 small sized SQL databases created on the server. The average transactions per database per day will be 10. That means on an average there will be 4000 transactions per day. The size of each database will not be more than 10 MB.

    Can anybody suggest what should be the ideal hardware configuration?

    Regards

    Prashant
    Last edited by prashant1979; 01-11-2008 at 04:30 AM. Reason: no signature present

  2. #2
    i would prefer dual xeon 1.8 or upper with 4GB ram

  3. #3
    Join Date
    Jul 2007
    Posts
    2,050
    Thanks a lot deapache.

  4. #4

    more memory

    I will strongly suggest that you go for as much memory that you can afford since sql transactions use memory. The queries are cached in the memory before it is committed to the disk. Now it has become a standard to have at least 2 GB of memory in a normal server. Also the memory modules have become more cheaper and affordable now.
    Mathew Augustine
    Systems Engineer
    "Drink nothing without seeing it; sign nothing without reading it."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •