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 Tuesday, January 12, 2010 2:54 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:34 AM
Points: 1,614, Visits: 898
It will show a row for every tracer token which has been added. According to BOL the information gets cleared after the history retention period of the distribution database. You can change this if you go to Distributor Properties in replication.
Post #845963
Posted Friday, January 15, 2010 3:41 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: Friday, September 26, 2014 10:20 AM
Points: 537, Visits: 1,921
thanks Rachel, is it accurate to get the information for each token? would'nt it be better to get the Get latency information for the last inserted token?, how does replication monitor get this information? in there I don't see multiple rows for the tokens, i ran your query and your results latency in seconds does not match my replication monitor information. Is there anything i need to change?
Post #848601
Posted Monday, January 18, 2010 2:04 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:34 AM
Points: 1,614, Visits: 898
I'm afraid your questions are beyond me... Maybe someone else can answer them.

Sorry,
Rachel.
Post #849015
Posted Wednesday, July 21, 2010 8:10 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 9:06 PM
Points: 658, Visits: 1,541
Hello. Will you please give directions for getting to the tracer token tab in SQL Server 2008. I can't find it by just poking around and I can't find instructions on line.
Thanks.
Post #956882
Posted Thursday, July 22, 2010 1:56 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:34 AM
Points: 1,614, Visits: 898
In Management Studio, right-click on the Replication folder and choose Launch Replication Monitor. In the Replication Monitor, coose the pulication you're interested in and you'll see the Tracer Tokens tab.

I assume that's what you mean?
Post #956978
Posted Thursday, July 22, 2010 3:28 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 9:06 PM
Points: 658, Visits: 1,541
Rachel Byford (7/22/2010)
In Management Studio, right-click on the Replication folder and choose Launch Replication Monitor. In the Replication Monitor, coose the pulication you're interested in and you'll see the Tracer Tokens tab.

I assume that's what you mean?


Yes, that's what I mean but I don't have a tab there...I click on the publication and find only 3 tabs: All Subscriptions, Agents, Warnings.

Know of this happening?
Post #957614
Posted Friday, July 23, 2010 2:06 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:34 AM
Points: 1,614, Visits: 898
Are you using transactional replication or merge replication? I have read that this tab is only available for transactional replication.
Post #957805
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse