MSDE - Bench Mark

  • Hi- Here is our setup. We have a central server at the corporate office and the configuration is extremely good. Then we need to have our application installed at the client sites too and all these sites communicate data back to the server periodically in the day. The configuration of the machine at the client site is horrible. It will be a PIII (< 1 GHz), 256MB and a HD size of 20 GB. This machine will have Win Prof, host the webserver, app server and the database server (MSDE). We would have like 6-7 databases sitting on this instance. DBs will be archived to maintain the 2G limit.

    And for reasons obvious, I am trying to convince my management that the configuration at the client will not work. So my question to the group is,

    1. Do you agree with me that the config at the client site will not work with what is planned for that machine?

    2. Can I find any numbers/benchmarks as to how much memory each of these take up etc because numbers is all that the management understands.

    Any help is greatly appreciated

    Thanks

  • There are other issues as well, how many concurrent users will try to reach this server? win2k pro only supports like 10 connections I think. There may be other limits you will need to address as well on the MSDE side. I have never personally used MSDE in a production enviornment but if it will support what you need it to do.

    Edited by - burthold on 05/27/2003 2:33:58 PM

  • Thanks for the reply. The number of users is not an issue in our situation as there will be at the most 3-4 users at any instance.

  • Without knowing the application I don't know if there will be an issue. I would run perfmon from the start and keep an eye on it. If this is a web based tool only I would run the stress test tool from Microsoft if you are looking for what to expect as far as performance over all.

    Wes

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

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