"medentmatt" <mattd@medent(dot)com.(donotspam)> wrote in message
news:CDDC7137-2D58-436B-967B-CF1A6111FD1E@microsoft.com...
> Quick question on MSDE maximum connections. If you use MSDE on several and
> the MSDE on each computers is pointing to one PCs MSDE, does that mean
> they
> are always connected regardless if the software you are using is
> requesting
> data or not? Meaning if you have 5 PCs pointing to one PC's MSDE, does
> that
> mean there are 5 constant concurrent connections?
> Also, if this is the case, whats the max connections you can have?
> --
> Thanks,
> Matt

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:ep%23Obh4SHHA.5016@TK2MSFTNGP05.phx.gbl...
>
> There is no limitation in connections; but in MSDE the performance will
> slow down if you have more than 5 concurrent batch (connections) running.
> After the 5th batch the Query Governer will stop working and will degrade
> performance.
>
> If 5 machines are connected using an application to MSDE, yes there will
> be 5 connections.