Tracer Token

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Mohan Kumar » Tracer Token

17 posts, Page 1 of 2

1 2 »»

Tracer Token

Rate Topic

Display Mode

Topic Options

Author

Message

Mohan Kumar

Posted Thursday, April 24, 2008 12:22 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 03, 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

Anipaul

Posted Friday, April 25, 2008 6:35 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 1:35 AM
Points: 4,789, Visits: 1,336

Nice one. :)

Post #490586

Mohan Kumar

Posted Friday, April 25, 2008 10:11 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 03, 2013 4:44 PM
Points: 1,336, Visits: 595

Thanks so much Anirban!!!

--www.sqlvillage.com

Post #490806

Raulie

Posted Wednesday, April 30, 2008 3:51 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 03, 2009 3:44 PM
Points: 105, Visits: 125

Cool Article.

Post #493317

Anipaul

Posted Wednesday, April 30, 2008 9:52 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 1:35 AM
Points: 4,789, Visits: 1,336

Mohan Kumar (4/25/2008)

Thanks so much Anirban!!!

You are welcome.....:P

Post #493396

Priya-313014

Posted Monday, February 02, 2009 10:57 PM

Valued 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

Ron Cicotte

Posted Tuesday, June 09, 2009 2:37 PM

Grasshopper

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

sqlqueue

Posted Sunday, June 14, 2009 1:02 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, August 06, 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

Rachel Byford

Posted Monday, July 27, 2009 9:08 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:27 AM
Points: 1,538, Visits: 802

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

DBA-640728

Posted Monday, January 11, 2010 7:12 PM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:21 PM
Points: 496, Visits: 1,724

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 »

17 posts, Page 1 of 2

1 2 »»

Permissions