Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 233
  • Last Modified:

How do I fix latency in transactional replication in SQL Server 2005?

We had to configure transactional replication in our clustered environment . The configuration was set correctly but after an hour or so we saw latency with a difference of 15 minutes or so. How do we investigate this and fix this?  Also, I would like to how logshipping and replication work in conjuction?
0
S R S
Asked:
S R S
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Open the Replication Monitor and check the information in the 'Undistributed Commands' tab.
Also, I would like to how logshipping and replication work in conjuction?
I don't know what it's really your question here but you can use logshipping on a database that it's used in a Replication solution no matter it function is (Publisher or Subscriber).
0
 
Eugene ZCommented:
it could be related to some process (s) that may run at the same time and that is blocking\locking server resources. if it is just an initial replication setup:
it can be acceptable during index run on subscriber..
check Replication Monitor  logs to see if replication setup is completed...
..
more:
Measuring Latency and Validating Connections for Transactional Replication
http://msdn.microsoft.com/en-us/library/ms151178(v=sql.90).aspx


and just in case
Troubleshooting Transactional Replication
http://sqlmag.com/database-administration/troubleshooting-transactional-replication
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now