Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Tracer Token Expand / Collapse
Author
Message
Posted Thursday, April 24, 2008 12:22 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 3, 2013 4:44 PM
Points: 1,336, Visits: 595
Comments posted to this topic are about the item Tracer Token

--www.sqlvillage.com
Post #489685
Posted Friday, April 25, 2008 6:35 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, August 14, 2014 12:26 AM
Points: 5,334, Visits: 1,383
Nice one. :)


Post #490586
Posted Friday, April 25, 2008 10:11 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 3, 2013 4:44 PM
Points: 1,336, Visits: 595
Thanks so much Anirban!!!

--www.sqlvillage.com
Post #490806
Posted Wednesday, April 30, 2008 3:51 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 3, 2009 3:44 PM
Points: 105, Visits: 125
Cool Article.
Post #493317
Posted Wednesday, April 30, 2008 9:52 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, August 14, 2014 12:26 AM
Points: 5,334, Visits: 1,383
Mohan Kumar (4/25/2008)
Thanks so much Anirban!!!

You are welcome.....:P



Post #493396
Posted Monday, February 2, 2009 10:57 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, December 18, 2011 11:39 PM
Points: 74, Visits: 121
In what way this is used? Using this how we can avoid the query time out?
Post #648581
Posted Tuesday, June 9, 2009 2:37 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 1:24 PM
Points: 13, Visits: 124
Please correct me if I'm wrong Mohan but I think the way this would be used is by inspecting the results and increasing the query timeout to a value greater than the max value of the results of your query. If the max value is extraordinarily high (minutes vs. seconds) then there are clearly other (presumably network related) issues.

Does this answer your question Priya


Ron Cicotte

Summer Street Systems
Post #731866
Posted Sunday, June 14, 2009 1:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 6, 2009 9:11 PM
Points: 42, Visits: 105
Hey , any body have query that will work on multiple subscriptions , this does not work on multiple subscription , i am looking like

publisher , subscriber , publisher_db ..

i tried below but it is working fine on one subscriber but i am looking if somebody can tweak it for multiple subscribers





SELECT distinct MM.Publisher as [Publisher Server],MI.subscriber as [Subscriber Server],MM.publisher_db as [Publisher DB],
datediff(mi, TT.publisher_commit,TH.subscriber_commit) AS [Latency From Publisher to Subscriber in Minutes],
datediff(mi, TH.subscriber_commit, (getdate())) AS [Time Difference in last Successful Transaction commit at subscriber to Current Time in Minutes]
FROM MSTracer_tokens TT(nolock)
JOIN MSTracer_history TH(nolock)
ON TT.tracer_id = TH.parent_tracer_id
join MSreplication_monitordata MM(nolock)
ON TT.publication_id=MM.publication_id
join MSsubscriber_info MI
ON MM.publisher=MI.publisher
join

(select max(tracer_id)s ,publication_id FROM MSTracer_tokens (nolock)

join
MSTracer_history(nolock)
on
tracer_id=parent_tracer_id
where
subscriber_commit IS NOT NULL
group by publication_id)xyz

on TT.tracer_id = xyz.s
Post #734550
Posted Monday, July 27, 2009 9:08 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 4, 2014 7:21 AM
Points: 1,614, Visits: 892
Not sure if this is quite what you wanted, but you can tweak the query in the article to add in the name of the publication and the name of the subscriber's distribution agent by joining MSpublications and MSdistribution_agents thus:

select MSpublications.publication,
MSdistribution_agents.name,
MSTracer_tokens.publisher_commit,
MSTracer_tokens.distributor_commit,
datediff(ss, MSTracer_tokens.publisher_commit, MSTracer_tokens.distributor_commit) 'Latency bw Pub and Dis',
MStracer_history.subscriber_commit,
datediff(ss, MSTracer_tokens.distributor_commit, MStracer_history.subscriber_commit) 'Latency bw Dis and Sub'
from MSpublications
inner join MSTracer_tokens
on MSpublications.publication_id = MStracer_tokens.publication_id
inner join MSTracer_history
on MSTracer_tokens.tracer_id = MSTracer_history.parent_tracer_id
inner join MSdistribution_agents
on MStracer_history.agent_id = MSdistribution_agents.id

Hope this helps,
Rachel
Post #760155
Posted Monday, January 11, 2010 7:12 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, July 20, 2014 1:08 PM
Points: 537, Visits: 1,918
hi Rachel, i tried using your query but can you tell me why does it show multiple rows for the same publication and name?
Post #845807
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse