MSDE Maximum Connections

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
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.
Thanks
Hari
"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.
It also depends on how the application that access MSDE is designed. If it
is designed in a ideal way, that is, connect to database server only needed
and close the connection as soon as the access is done. Then even with
MSDE's 5 concurrent work load limitation, an MSDE can well serve a lot more
users who need to access data from time to time 20, 50 or even hundreds,
really depends how the the data is accessed.