> Hi all,
>
> Is it true that MSDE can only handle 5 concurrent
> connections? I cant seem to find the proof in the
> documentation that this is true.

On Mon, 18 Apr 2005 03:27:51 -0700, chris wrote:

>Hi all,
>
>Is it true that MSDE can only handle 5 concurrent
>connections? I cant seem to find the proof in the
>documentation that this is true.

"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
news:0v1861pak4dhf7qhvdlodfno2s4unlqil4@4ax.com...
> On Mon, 18 Apr 2005 03:27:51 -0700, chris wrote:
>
>>Hi all,
>>
>>Is it true that MSDE can only handle 5 concurrent
>>connections? I cant seem to find the proof in the
>>documentation that this is true.
>
> Hi Chris,
>
> It isn't true.
>
> MSDE imposes no limit on the number of connections. It does impose a
> limit on the number of concurrent workloads (i.e. internal threads in a
> busy state - usually executing your queries). The limit is set to 8
> concurrent workloads, but internal processes take away the first 3,
> leaving you with 5 to spend for your goals. If more than 8 workloads are
> active at the same time, performance for all workloads is throttled. ANd
> the more you exceed the limit, the more the performance will be
> throttled.
>
> In a typical data-entry situation, you can easily exceed 20 or even 40
> connections - if the data entry screens are complex and the server-side
> processing limited, you could even hit 100 connecitons without problems.
>
> On the other hand: if you use complex processing, using a client to
> spawn multiple sessions, each executing complex and time-consuming
> queries in parallel to each other, then executing the process from just
> one computer at a time might already be enough to exceed the limit and
> degrade the performance.
>
> http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)