I didn't see detail to the final error message, but then did with the
previous message:
Timeout expired
(Source: ODBC SQL Server Driver (ODBC); Error number: 1003)
---------------------------------------------------------------------------------------------------------------
IDistPut Interface has been shut down.
(Source: (Agent); Error number: 2000)
-------------------------------------------------------------------
So I'm assuming that "Timeout Expired" is the root cause and means the
QueryTimeout parameter needed to be increased.
Michelle
[quoted text, click to view] "Paul Ibison" wrote:
> Have a look at the error details to get more info. It
> could have been a querytimeout issue. On the other hand
> this morning one of my log reader agents reports:
> "The SQL Server cannot obtain a LOCK resource at this
> time. Rerun your statement when there are fewer active
> users or ask the system administrator to check the SQL
> Server lock and memory configuration.
> (Source: servername (Data source); Error number: 1007)"
> This is the detailed error message from exactly the same
> error as the subject of your message and is not related
> to timeouts per se, but to a longstanding issue where
> there is a series of blocking jobs which exceeds the
> total lock allocation.
> Rgds,
> Paul Ibison SQL Server MVP,
www.replicationanswers.com >
> (recommended sql server 2000 replication book:
>
http://www.nwsu.com/0974973602p.html)
>
Michelle,
in that case I fully agree. I have had to increase this
parameter myself for the same reason. I have used the
value 0 which is reported to mean infinity, although
there is a little contention about this. In your tests,
each time you were increasing the QueryTimeout and
running the logreader, I believe more records were being
removed from the log, so the fact that after the last
increase the log was read in 5 minutes was probably a
little misleading. If it happens again, you can run
sp_replshowcmds to be sure what is happening.
Rgds,
Paul Ibison SQL Server MVP,
www.replicationanswers.com (recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
