Re: Distribution agent action messages in session details

Is it a good idea to increase the query timeout from 300 seconds (default) to
maybe 600 seconds in Distribution Agent profile to accomendate any potential
long running process?

Wingman



"Hilary Cotter" wrote:

> The replication subsystem issues commands and waits for responses. If it
> doesn't get a response in a predetermined amount of time it gives the
> waiting for a response from one of backend connections.
>
> I can't explain why no-one could connect - perhaps the database or tlog was
> auto-growing at that time.
>
> --
> 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
>
> "Wingman" <Wingman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:76F91F8B-925F-4152-9C2D-ACB9EA89FCD5@xxxxxxxxxxxxxxxx
> > We are using SQL 2K std with SP4 and push subscription. We have situation
> > between our publishing SQL server and subcribing SQL server.
> >
> > Here is what I see when I double click an action message (listed as
> > Timeout
> > Expired) in the listing of Distribution Agent history.
> >
> > 3:24 pm Initializing
> > 3:29 pm The process is running and is waiting for a response from one of
> > the backend connections.
> > 3:29 pm Timeout expired
> >
> > The sequence of action took exactly five minutes. And the timeout
> > happened
> > again at 3:30 pm and last until 3:35 pm. Then at 3:36, it started working
> > and delivered the transactions.
> >
> > Can someone tell me what the 'backend connection' the distribution agent
> > is
> > waiting for?
> >
> > Also, during this problem period, both publishing and subscribing SQL
> > servers all of a sudden became activity dead meaning there is no IO and no
> > SQL internal activity (my perf monitor showed almost a blank screen except
> > cpu time), the publishing SQL server's cpu time is very minimal but the
> > subscribing SQL server's cpu is 60% peak and no IO. I checked the proces
> > of
> > the CPU in Em and it was for replication but it had long wait time. It
> > looked all a sudden nobody can connect to the SQL servers. In fact, we
> > confirmed that users can't connect to the web application that use SQL
> > servers. I don't see any networking error shown in the event log in both
> > servers. I am assuming there is a 'disconnect' or something is 'hanging',
> > I
> > like to know if the 'disconnect or hanging' caused the distribution agent
> > to
> > time out or the distrbitution timeout problem caused the SQL server system
> > to
> > become 'disconnect or hang'?
> >
> > wingman
> >
> >
> >
>
>
>
.

Relevant Pages

  • Re: Distribution agent action messages in session details
    ... QueryTimeout is more often used in merge replication than in transactional ... >> Looking for a SQL Server replication book? ... >>> Expired) in the listing of Distribution Agent history. ... >>> cpu time), the publishing SQL server's cpu time is very minimal but the ...
    (microsoft.public.sqlserver.replication)
  • RE: Problem: Changing the SQL Server services password
    ... be guaranteed a response within two business days according to the service ... Are the passwords of SQL Server service account and Microsoft Cluster ... By default the error logs are located in the folder ...
    (microsoft.public.sqlserver.server)
  • Re: VS2005 - Merge Rep Performance.
    ... I am working on MR on VS2005 and kind of am interested in your response. ... so I successfully converted my VS2003 CF application to VS2005 including an update from SQL Server CE to SQL Server Mobile Edition and an update of the merge replication agent from sqlcesa20.dll to sqlcesa30.dll. ... Is it faster if you hit SQL Server 2005 on the back end, and slower if you are hitting SQL Server 2000? ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Access 2007 and MySQL
    ... think that response was worth posting? ... post more as a recommendation to use SQL Server instead of MySQL ... is better than your original post at addressing the question asked. ...
    (comp.databases.ms-access)
  • RE: Error installing (KB 921896)
    ... I have not seen any sort of response to this inquiry for 2 ... the SQL Server Instance is set to Mixed Authentication ...
    (microsoft.public.windowsupdate)