Re: agents blocking each other
From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 03/01/05
- Next message: Hilary Cotter: "Re: agents blocking each other"
- Previous message: Hilary Cotter: "Re: agents blocking each other"
- In reply to: Kristy: "Re: agents blocking each other"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Mar 2005 06:57:22 -0500
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... > 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... > > 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 > > > > > > > > > > > >
- Next message: Hilary Cotter: "Re: agents blocking each other"
- Previous message: Hilary Cotter: "Re: agents blocking each other"
- In reply to: Kristy: "Re: agents blocking each other"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
