STS FAQ - Why shouldn't I simply use the default MSDE...

Section:

SubSection:

Number:

Title:

Why shouldn't I simply use the default MSDE ?

Body:

Microsoft have (in this newsgroup) stated that you should use MSDE for up to ca. 5 users. This comes from the MS STS Performance paper (II.18.1) which states that "MSDE is throttled for about five concurrent users".

Brian Moran said in a recent SQL Server newsletter that "A query governer limits database performance when MSDE executes more than 5 batches concurrently, database size is limited to 2GB and the engine lacks GUI administration tools" (so you have to use SQL Server tools (or similar) which is probably against the licensing rules for them).

MS also says in the Performance paper that MSDE is "fine for small workgroups" which seems to be in conflict with the previous 5 limit. The answer is that the 5 figure is concurrent users and the small workgroup presumably consists of more users that do not all access the site at the same time.

If you are going to be serious about using STS company-wide you should probably be looking at SQL Server.

For a new installation I would go for SQL Server 2000 simply because it is newer and will be supported by Microsoft for longer.

Link:

6. - Why shouldn't I simply use the default MSDE ?

Attachments:

Created at 5/27/2005 6:56 PM by Jim

Last modified at 5/27/2005 7:02 PM by Jim