Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ward0517
Starting Member
2 Posts |
 Posted - 2009-11-06 : 09:37:54
|
| Hello,I'm new to replication. I have setup a transactional replication job on SQL 2005 as the publisher and distributer and SQL2000 as a pull subscriber. I have this setup up for continuous replication. Replication works fine with no errors. However we connect to the subscriber DB through Microsoft Access and an ODBC connection. There are numerous queries that are run inside Access. With the replication running the queries will continually receive a generic timeout error. If I stop the replication job on the subscriber, the queries will run.I'm not sure if there is a locking issue or what. I must be missing something because what good is a continuous replication job if you can't query the subscriber DB.Any help would be appreciated.Thanks,Chris |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2009-11-06 : 12:09:12
|
| Trans replication will not block queries. Check the performance of the replication, ie the time for sync in the Rep MonitorThanks,Krishnawww.SQLServer.in |
 |
|
|
ward0517
Starting Member
2 Posts |
Posted - 2009-11-06 : 13:58:32
|
| The replication monitor shows the performance is "Excellent" and the Latency is hovering between :01" and ":05".So the performance looks ok, but even if it weren't how would that cause the queries to time out?Thanks Chris |
|
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2009-11-23 : 09:54:07
|
| sorry for the late reply.Check out if you there are any blocks through profiler may be. Replication , once started in sync, will not lock any resourcesThanks,Krishnawww.SQLServer.in |
|
|
|
|
|
|
Timeout querying Subscriber DB when replicating