Re: MSDE Performance and Reliability

Robert Baker wrote:
I believe the the Express edition has a limit on the number of connections and the size of the DB. Last I remember was 5-10 connecttionas and 2gb. I could be wrong on this, but I think the idea is free for small application and then pay when you grow.

Hi,

The limits for Express edition are.

Supports 1 CPU
1 gigabyte (GB) addressable RAM
4 GB maximum database size

http://www.microsoft.com/sql/editions/express/features.mspx

The 2 GB database size limit was for MSDE.
I have never heard that there would be a limit in the number of connections but MSDE was said to be *optimized* for 5 concurrent users.
That optimization was implemented as a throttle :).

Here is a comparison between MSDE and SQL Server Express.
http://technet.microsoft.com/en-us/library/ms165672(SQL.90).aspx

regards

/Micke
.