Results 1 to 2 of 2

Thread: SPTS and MSDE

  1. #1
    New Lounger
    Join Date
    May 2002
    Thanked 0 Times in 0 Posts

    SPTS and MSDE

    I am proposing a SharePoint Team Services site for my department. I am already resigned to purchasing a PC with W2K Server (vice a spare PC with W2K Pro), but do not wish to spend money or resources on SQL Server.

    For a site with about 150 users and less than 1000 documents, would MSDE suffice?


  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Silicon Valley, USA
    Thanked 94 Times in 90 Posts

    Re: SPTS and MSDE

    MSDE contains the SQL Server engine, but restricts its use. The limit is not 5 users, although MS doesn't mind if you misinterpret its vague statements that way. Some SQL Server 2000 documentation I found up at MS describes the performance limit this way: "a concurrent workload governor that limits its scalability; performance degrades when more than five Transact-SQL batches are executed concurrently."

    What does this really mean for SharePoint? I have no idea. But with 150 users, you might bump into the performance governor on a regular basis. You probably have to test it for yourself with the mix of uses you are planning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts