Comparing msde with sql server 2005 express.

Hi, we have some applications running on a msde 2000. We are evaluating
to change it to sql express 2005. Do you know if this new version
support more concurrent conections than msde?
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Express doesn't have the throttler (which added a wait for each I/O when you had more than 8
concurrently executing queries). So the answer is:
Most probably yes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"MariaGuzman" <marisa@.devdex.com> wrote in message news:%23ZqFCqJDGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Hi, we have some applications running on a msde 2000. We are evaluating
> to change it to sql express 2005. Do you know if this new version
> support more concurrent conections than msde?
> Thanks a lot for your help.
>
> *** Sent via Developersdex http://www.codecomments.com ***
|||MSDE had an internal governor that scaled back performance based on an
algorithm that involved several pieces. Most people believed there was a
limit to the number of users but that was not true, it just seemed that way.
SQLExpress does not have this governor and does not have any limits on the
number of users. But that said there are other aspects of Express that may
impact performance or the ability to support many connections. Hardware
plays a factor as well. See here for details on what Express supports and
what it does not.
http://www.microsoft.com/sql/edition...s/default.mspx
Andrew J. Kelly SQL MVP
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:%23ZqFCqJDGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Hi, we have some applications running on a msde 2000. We are evaluating
> to change it to sql express 2005. Do you know if this new version
> support more concurrent conections than msde?
> Thanks a lot for your help.
>
> *** Sent via Developersdex http://www.codecomments.com ***