Re: MSDE questions
From: Brian Hollister (bhollisterATfuturaintlDOTcom)
Date: 11/06/03
- Next message: Betsy: "adoProc.params not found... huh?"
- Previous message: Mike Thompson: "MSDE questions"
- In reply to: Mike Thompson: "MSDE questions"
- Next in thread: Guillermo Castaņo A: "Re: MSDE questions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 6 Nov 2003 11:56:11 -0500
> 5. The current application that under access has about 150 users logging
in
> at various during the day. Don't know what the largest concurrent value is
> but the application is optimized and hasn't shown any major (noticeable by
> the user) issues. Can MSDE support the same? I noticed in several posts
that
> their is a 5 user or thread limit or something.
http://www.microsoft.com/sql/msde/productinfo/default.asp
use the above link for a Produt Overview, Features, and System Requirements
This exceprt came from the Features page that can be found using the link
above;
Performance
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.
- Next message: Betsy: "adoProc.params not found... huh?"
- Previous message: Mike Thompson: "MSDE questions"
- In reply to: Mike Thompson: "MSDE questions"
- Next in thread: Guillermo Castaņo A: "Re: MSDE questions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
