SharePoint 2003 Limitations using WMSDE

Q: I want to use WMSDE for a very limited POC (proof of Concept) of SPS 2003. Other than Search and performance, are there any other things to be concerned about?

A: If SPS 2003 is not installed WSS uses a special version of MSDE, known as SQL Server 2000 Desktop Engine (Windows), or WMSDE. This is an unthrottled version of MSDE designed only to be used by Windows components, and as such is not limited in the same way as MSDE. The maximum size limit and current connections limit have both been removed. However it is still much more limited than SQL Server 2000 in the following ways:

  • WMSDE does not include enterprise management tools such as those provided with SQL Server 2000 (e.g. SQL Enterprise Manager MMC tool) for backing up and restoring the database. However command line tools can still be used (e.g. stsadm tool).
  • WMSDE can only be managed locally – you cannot remotely connect.
  • WMSDE does not support full-text search – so search from within team sites is not possible.
  • You cannot deploy WMSDE in web farm/clustered configurations, so the solution cannot scale beyond certain limits, and remains a single point of failure.
  • You cannot use WMSDE for anything other than WSS due to the custom schema it uses (MSDE or SQL Server 2000 can also be used for other custom applications). There is no user interface to edit the database file.
  • WMSDE will support a maximum of 1000 web sites.


For more information, goto http://blogs.msdn.com/grahamtyler/archive/2004/10/19/244496.aspx

Comments

Ishai Sagi [SharePoint MVP] said…
another thing - msde supports up to 8 concurrent users. the 9th user goes into a queue and expiriences preformance issues.
I measured the preformance degragation and it gets worse and worse after 8 users.
July 19, 2006 12:05 AM
Sam Nasr said…
Ishai, thanks for your comment. The SharePoint Resource kit indicated MSDE has a limit of 5 concurrent connections and a DB size limit of 2GB. However, please note this blog entry discusses using WMSDE, not MSDE. WMSDE does not have those two limitations. For more information on MSDE and WMSDE, please check out the link in the original post. Thanks again for your comment, and please keep them coming!
July 19, 2006 1:01 PM
Post a Comment

Popular posts from this blog

Working with double quotes (") in VB.Net

String manipulation in VB2005 is fairly simple. However, things can get a little tricky with the double quote character. How do you look for it in a string? How can you insert into a string? How do you remove it from a string? These are questions that may lead to confusion if you don't know what you're looking for. Ironically enough, in VB the double quote can also be used as an escape character when searching for it in a string. For example: Dim strTest As String strTest = """123""" 'Displays "123" (double quotes appear in the final result) strTest = """""123""" 'Displays ""123" (double quotes appear in the final result) strTest = "test\""test" 'Displays test\"test strTest = "test""test" 'Displays test"test In cases where you want to insert a double quote character, simply reference it unicode character designation, ch...
Read more

FoxCon 2019

This year I had the privilege of being invited to FoxCon for the 5th time.  FoxCon is a private invite-only conference.  It was started decades ago when FoxPro was one of the products from Microsoft.  Although the product is no longer supported, it is still widely used and loved at many organizations of various sizes.  The FoxCon conference targets FoxPro related topics but the organizers are always open to hear new topics. This year I presented 2 sessions: "SQL Server Security"  and "New Features in SSRS 2017".  Presenting to a technical audience is something I have always enjoyed.  However, it seems much more enjoyable presenting to this group of tech experts. I look forward to attending and possibly presenting again next year.
Read more

Sep '19 Announcements

Listed below are announcements of developer events local and regional to the Cleveland area.  In addtion there are links to job openings and videos of past presentations. Local Events: Oct 1: ONSQL-Cleveland ( https://www.meetup.com/Ohio-North-SQL-Server-User-Group-Cleveland/ ) Oct 16: Hudson Software Craftsmanship Group ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ ) Oct 24: Cleveland C#/VB.Net User Group ( https://www.meetup.com/Cleveland-C-VB-Net-User-Group/ ) Regional Events: Oct 1: ONSQL-Cleveland ( https://www.meetup.com/Ohio-North-SQL-Server-User-Group-Cleveland/ ) Oct 16: Hudson Software Craftsmanship Group ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ ) Oct 24: Cleveland C#/VB.Net User Group ( https://www.meetup.com/Cleveland-C-VB-Net-User-Group/ ) Job Openings: TekSystems:  https://www.teksystems.com/it-jobs Inedo:  https://inedo.com/company/career-culture Video: Please subscribe to  https://www.youtube.com/channel/UCU4ffaI...
Read more