agents blocking each other

Contantly there seems to be a blocking issue between the distribution agent,
the log agent, and the distribution clean up agent.
This will eventually cause one of the agents to shut down (the log agent).
What can I do to elevate this situation and why is it happening?
--Kristy
Avoid using EM.
Through Query Analyzer run the distribution clean up agent at a time when
there are few users on the system.
Consider moving to pull subscriptions and possibly a remote distributor.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kristy" <pleasereplyby@.posting.com> wrote in message
news:%235Ev4idHFHA.3628@.TK2MSFTNGP15.phx.gbl...
> Contantly there seems to be a blocking issue between the distribution
agent,
> the log agent, and the distribution clean up agent.
> This will eventually cause one of the agents to shut down (the log agent).
> What can I do to elevate this situation and why is it happening?
> --Kristy
>
|||Thanks.
Why is it happening and what do the suggestions you provide buy me? Also,
would it be okay to schedule a job to run it? That way the off peak hours
could be utilized best. (I do have to sleep at some point ;-) )
Thanks again,
(and still anxiously awaiting my order to arrive)
Kristy
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u0iLc2gHFHA.2132@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Avoid using EM.
> Through Query Analyzer run the distribution clean up agent at a time when
> there are few users on the system.
> Consider moving to pull subscriptions and possibly a remote distributor.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Kristy" <pleasereplyby@.posting.com> wrote in message
> news:%235Ev4idHFHA.3628@.TK2MSFTNGP15.phx.gbl...
> agent,
agent).
>
|||In addition Hilary, what does pull subscriptions offer over push ?
"Kristy" <pleasepostreply@.here.com> wrote in message
news:enALdThHFHA.1176@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Thanks.
> Why is it happening and what do the suggestions you provide buy me? Also,
> would it be okay to schedule a job to run it? That way the off peak hours
> could be utilized best. (I do have to sleep at some point ;-) )
> Thanks again,
> (and still anxiously awaiting my order to arrive)
> Kristy
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u0iLc2gHFHA.2132@.TK2MSFTNGP14.phx.gbl...
when
> agent).
>
|||EM, does lots of enumeration and runs far more commands than a simple
command (lets say sp_addsubscription) does. Run profiler to see this.
So if you run a command directly in isqlw you get far less locking.
You can schedule a job to run it, but then you have to log error messages
and make sure that everything runs fine. I would advise you to set your
alarm for 2:00 AM and then log in and do it at that time.
Another thing you can do is stop SQL Server Agent, make your change, and
then restart it.
Pull subscribers run the distribution agent on the subscriber, it connects
with the distribution database on the publisher and results in better
performance on the publisher and less locking.
You might also want to stagger when you agents run - for instance stagger
them to run at a prime number - like every 7 minutes, and don't run them
continuously.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kristy" <pleasepostreply@.here.com> wrote in message
news:enALdThHFHA.1176@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Thanks.
> Why is it happening and what do the suggestions you provide buy me? Also,
> would it be okay to schedule a job to run it? That way the off peak hours
> could be utilized best. (I do have to sleep at some point ;-) )
> Thanks again,
> (and still anxiously awaiting my order to arrive)
> Kristy
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u0iLc2gHFHA.2132@.TK2MSFTNGP14.phx.gbl...
when
> agent).
>
|||btw - with pull subscriptions you have no central point of administration.
For instance, with push you connect to your publisher in EM and manage your
replication solution. With pull you have to connect to each subscriber and
expand replication monitor to see errors. Make sure you use Replication
Monitor Group to show all your subscribers (use Tools, Replication, Show
Replication Monitor Group and go to the bottom node and right click on
Replication Monitor Group and select add distributor to monitor).
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kristy" <pleasepostreply@.here.com> wrote in message
news:enALdThHFHA.1176@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Thanks.
> Why is it happening and what do the suggestions you provide buy me? Also,
> would it be okay to schedule a job to run it? That way the off peak hours
> could be utilized best. (I do have to sleep at some point ;-) )
> Thanks again,
> (and still anxiously awaiting my order to arrive)
> Kristy
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u0iLc2gHFHA.2132@.TK2MSFTNGP14.phx.gbl...
when
> agent).
>
|||answered above.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eQ1oolhHFHA.2420@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> In addition Hilary, what does pull subscriptions offer over push ?
> "Kristy" <pleasepostreply@.here.com> wrote in message
> news:enALdThHFHA.1176@.TK2MSFTNGP12.phx.gbl...
Also,[vbcol=seagreen]
hours[vbcol=seagreen]
> when
distributor.[vbcol=seagreen]
distribution
>