<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Mohan Kumar
»
Tracer Token
17 posts, Page 2 of 2
««
1
2
Tracer Token
Rate Topic
Display Mode
Topic Options
Author
Message
Rachel Byford
Rachel Byford
Posted Tuesday, January 12, 2010 2:54 AM
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 9:27 AM
Points: 1,538,
Visits: 802
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
DBA-640728
DBA-640728
Posted Friday, January 15, 2010 3:41 PM
SSC-Addicted
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:21 PM
Points: 496,
Visits: 1,724
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
Rachel Byford
Rachel Byford
Posted Monday, January 18, 2010 2:04 AM
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 9:27 AM
Points: 1,538,
Visits: 802
I'm afraid your questions are beyond me... Maybe someone else can answer them.
Sorry,
Rachel.
Post #849015
KoldCoffee
KoldCoffee
Posted Wednesday, July 21, 2010 8:10 PM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 8:44 PM
Points: 443,
Visits: 1,011
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
Rachel Byford
Rachel Byford
Posted Thursday, July 22, 2010 1:56 AM
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 9:27 AM
Points: 1,538,
Visits: 802
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
KoldCoffee
KoldCoffee
Posted Thursday, July 22, 2010 3:28 PM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 8:44 PM
Points: 443,
Visits: 1,011
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
Rachel Byford
Rachel Byford
Posted Friday, July 23, 2010 2:06 AM
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 9:27 AM
Points: 1,538,
Visits: 802
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 »
17 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
