Performance of MSDE Vs. SQL Server 2000

Hi there. I understand that MSDE has limitation such as 25 concurrent
users. However, under the same number of concurrent user environment
(say, 1 user) and hardware, is it possible that there will be much
performance difference between MSDE and SQL Server 2000?
What if MSDE runs under XP Pro and SQL SErver 2000 under Windows 2000?
Thanks
Dom<domtam@.hotmail.com> wrote in message
news:1130287729.767464.93730@.g43g2000cwa.googlegroups.com...
> Hi there. I understand that MSDE has limitation such as 25 concurrent
> users. However, under the same number of concurrent user environment
> (say, 1 user) and hardware, is it possible that there will be much
> performance difference between MSDE and SQL Server 2000?
> What if MSDE runs under XP Pro and SQL SErver 2000 under Windows 2000?
>
MSDE has no limit on concurrent users. It has a workload governer which
slows down processing when there are more than 5 concurrent workloads (not
users or connections). In addition databases are limited to 2GB each.
Within the limitations of MSDE the performance should be similar.
The replacement for MSDE, SQL Server 2005 Express Edition has no governor or
user limitation, but is limited to using 1GB of ram, 1 processor and
databases are limited to 4GB each.
David