SQL Server Performance

Wich version to deploy

Discussion in 'SQL Server 2005 General Developer Questions' started by Davy, Nov 17, 2005.

  1. Davy New Member

    I'm deploying an ASP .Net application on which 20 users will be working at the same time. The database will start at less than 100mb. Is SQL EXPRESS 2005 powerfull enough to use for such an application.

    Thanks in advance for your answers
  2. surendrakalekar New Member

    http://www.microsoft.com/technet/community/chats/trans/sql/SQL_081004.mspx



    Surendra Kalekar

  3. mulhall New Member

    Depend on the features you are after; I would suggest from the marketing schpiel that they are aiming the Workgroup edition at your kind of deployment.
  4. Davy New Member

    Thanks for your replies.

    From what I read, it seems that there isn't any drawback to deploy to SQL Server Express for the kind of web app I'm building. I'm just not sure about the speed. Does anyone know if there is a big speed difference between SQL Sever 2005 Express and Standard editions? If so where do these performance differences come from?

    Thanks again.
  5. druer New Member

    In my opinion 80% of performance has to do with the database design and the indexes on the tables. If you construct the proper indexes and have a good maintenance plan in place to maintain the indexes and don't do silly things like have the application pass queries that ask for 1 million rows of data, then any version of SQL Server running on any box (including a calculator) would keep pace with what you are putting out there for that number of users.(ok slight exaggeration at least an adding machine) just my opinion
  6. derrickleggett New Member

    The biggest differences to me between Express and Workgroup are processor count and memory count. Express supports 1GB of RAM and 1 processors. Workgroup supports 3GB of RAM and 2 processors. If you want to start with Express, you can always upgrade later to the workgroup edition. If you start putting a lot of load on this server and have more data that needs to be cached, you'll want to take advantage of the extra RAM in Workgroup. It can't hurt to try Express though, unless this is a high customer visibility website and you just don't want to take chances.


    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.

Share This Page