Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003

    Unanswered: msde # of users allowed.

    i have a questions concerning msde 2000.

    1- how many user can access an msde database at one time?
    (some resources say 5 some sau unlimited.)

  2. #2
    Join Date
    Jan 2003
    I believe it is 10

  3. #3
    Join Date
    Oct 2001
    You can find complete information here:
    MSDE 2000
    here is an excerpt from this page:
    MSDE 2000 is a local data engine that can be shared. It has a managed concurrency workload governor that limits up to five concurrent batch workloads for optimal performance. Commands and log entries are available to monitor instances where more than five workloads are executed concurrently, a situation that can cause slower performance even on well-tuned systems. As more batch workloads are submitted beyond the five-workload limit, the concurrency governor continues to slow down the system. These workloads are not dropped or lost; they are still processed, but in an increasingly degraded performance mode. If your solution must support more than five concurrent workloads, it is highly recommended that you migrate to SQL Server 2000 or SQL Server 2000 Enterprise Edition for optimal performance at this higher level of scalability.
    Hope this helps

  4. #4
    Join Date
    Feb 2003

    in laymans terms

    MSDE 1.0 (SQL 7) had a governor on the # of connections.

    MSDE 2.0 (SQL 2k) just has a governor on concurrent processes.

    so with MSDE 2.0, you can have 25 connections that stay open all the time-- and it works like a charm.

    with MSDE 1.0, you would be going really slowly.

    if you're asking 'is this the right solution for me'

    i think that the answer is yes.

    but you'll have to give us more information about your project before we can come to the correct diagnosis.
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

Posting Permissions

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