MSDE # connections

Hello All-
We are doing some performance monitoring of clients. We are running merge
replication ( push) on SQL Server 2000. Clients use MSDE.
We notice that merge replication is taking 5 connections to the client. I
thought that MSDE had a max 5 concurrent connections and then adds a
performance penalty when above 5. Our concern is that when our app connects
to MSDE, we are getting a big performance hit.
Is it valid for merge replication to take 5 connections? We verified this
number by monitoring and then stopping & restarting merge agent. The number
went from 7 ( merge agent at central db host enabled ) to 2 connections (
merge agent stopped).
Thanks,
bruce
actually its 8 simultaneous connections. Subsequent connections are
throttled. However if you run sp_who2, you will find that many of these
connections are sleeping, which means that they are not doing work.
So the short answer to your question is that you should not experience a
significant performance hit as long as you have only a few clients
connecting.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"rr" <bruceradtke@.REMOVEspamREMOVE.earthlink.net> wrote in message
news:b79Nc.104089$a92.87050@.twister.nyc.rr.com...
> Hello All-
> We are doing some performance monitoring of clients. We are running merge
> replication ( push) on SQL Server 2000. Clients use MSDE.
> We notice that merge replication is taking 5 connections to the client. I
> thought that MSDE had a max 5 concurrent connections and then adds a
> performance penalty when above 5. Our concern is that when our app
connects
> to MSDE, we are getting a big performance hit.
> Is it valid for merge replication to take 5 connections? We verified
this
> number by monitoring and then stopping & restarting merge agent. The
number
> went from 7 ( merge agent at central db host enabled ) to 2 connections (
> merge agent stopped).
> Thanks,
> bruce
>
>