SQL 2005 replication question

[kodaksmile]

We keep seeing the following message in our preproduction cluster that is using a pull subscription for a reporting database:

Replication-Replication Distribution Subsystem: agent %S% scheduled for retry. Query timeout expired

We checked the basic performance counters and didn't see much activity on the server. Also checked in with the testing team that said they weren't doing anything on the system. A different group was running reports that do return a large amount of data and run for about 10-15 minutes for each report.

Any suggestions? My concern is that replication will get broken and this db is several hundred gig so rebuilding it takes some time....

 

[mrdenny]

Odds are the reports are causing locking somewhere, which is causing the replication to timeout. Run the reports again and see where the locking is happening, then resolve the locking issue.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog