Replication & Latency

  • Hi,

    I am setting up the replication. I heard there are some stored procedures to check the latency. Please let me know those stored procedures names to find the latency b/n publisher & subscriber.

    And what stored procedure we have to use when I want to delete old data from publisher and doesn't want reflect those deletion operation in the subscriber.

    Thanks in advance.

  • If you want to do it programmatically have a look at:

    sp_posttracertoken

    http://technet.microsoft.com/en-us/library/ms176091.aspx

    and

    sp_helptracertokenhistory

    http://technet.microsoft.com/en-us/library/ms187349.aspx

    A bit more reading here: http://technet.microsoft.com/en-us/library/ms147309(v=sql.105).aspx

    Otherwise, you can always insert a tracer in Replication Monitor> Select the Publication> and "Insert Tracer"

    As far as deleting data from the publisher, but leaving at the subscriber... hmmm. That sort of defeats the purpose of replication (as designed). You might transfer those records out of the subscriber table into another non-replicated table to save them? Sounds like you might be using replication as an archiving solution?

    Todd Carrier
    MCITP - Database Administrator (SQL 2008)
    MCSE: Data Platform (SQL 2012)

  • Thank you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply