(Msg. 1) Posted: Tue Apr 07, 2009 12:04 pm
Post subject: SQL Server 2005 Average Latency Archived from groups: microsoft>public>sqlserver>replication (more info?)
In the replication monitor if I expand one of my publishers and select one of
my publications I can see the latency. Is there a way I can get the average
latency for a specific subscription. I am interested in enhancing the
performance of our replication environment but before I start tweaking
paramters like -MaxCmdsInTran and -SubscriptionStreams etc. I'd like to be
able to calculate the average latency so I can see if the changes I introduce
into the system have had a positive or negative impact on performance.
Mainly latency.
(Msg. 2) Posted: Thu Apr 09, 2009 9:20 am
Post subject: RE: SQL Server 2005 Average Latency [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You could use tracer tokens for this
(http://www.replicationanswers.com/TracerTokens.asp)
Or you could use this query:
select * from distribution.dbo.MSdistribution_history
HTH,
Paul Ibison, www.replicationanswers.com
Replication Latency - Hi: Latency is very high in replication monitor even though I don't see any commands to be applied in sp_browsereplcmds. Do you know from where it gets the latency number from in distribution database because it is misleading? Thanks
Understanding Latency - Greetings, I have recently started working in an environment that uses replication extensively. As part of that there are times where we are seeing some high latency times. I am wondering if there are some key queries that I can use to get some..
Web Suscription of a SQL Server 2005 CE client to a SS 200.. - Hello: Production environment configuration: 1 Server running SQL Server 2005 containing the publications. This is the publisher (name : PUB) 1 Server running SLQ Server 2005 containing suscriptions. This is the Distributor (name : DIST) 1 Server..
Latency In Transactional Replication - During last couple of weeks some new Tables & Fields were added. SO both the time i have to re-intialize the Replication. my question is about LATENCY where i have seen for both the subscriber(SUB) for SUB-1 is 3.5 Hours & SUB-2 is 21 hrs. Siz...
Replication latency is high - Hi Guys, In my company, we have a transaction replication that replicates data from OLTP database to report database, where the distribution database is in subscriber server, so it is a pull publication mode. In repport DB(subscription), we have..
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
FAQ
Search
Profile
Private Messages
Log in
