Post reply

Replication Lactency with out Tracer Tokens

  • January 11, 2012 at 9:52 am

    #262696

    Hi

    Im looking for ways to view replication latency using script and without the use of tracer tokens does anyone have any ideas? iv tried the google thing with no luck..

    even found something on SSC but seems the query doesnt display any results... here[/url]

    Anyone have any ideas

    Thanks

  • January 11, 2012 at 9:55 am

    #1431938

    We have a script... Let me find it for you and I will post it shortly.

    Jared
    CE - Microsoft

  • January 11, 2012 at 9:57 am

    #1431941

    Thanks alot much appreciated :hehe:

  • January 11, 2012 at 10:07 am

    #1431948

    select

    pub.srvname,

    sub.srvname,

    publisher_db,

    subscriber_db,

    a.publication,

    convert(varchar,current_delivery_latency/60000)+' minutes '+ convert(varchar,(current_delivery_latency%60000)/1000)+' seconds'+' ('+convert(varchar,current_delivery_latency/1000)+' seconds)',

    convert(varchar(1000),comments),

    convert(varchar,time,21),

    current_delivery_latency

    from distributerServerName.distribution.dbo.MSdistribution_agents a

    join distributerServerName.distribution.dbo.MSdistribution_history h

    on a.id=h.agent_id

    join distributerServerName.master.dbo.sysservers pub

    on a.publisher_id=pub.srvid

    join distributerServerName.master.dbo.sysservers sub

    on a.subscriber_id=sub.srvid

    where a.id=h.agent_id

    and current_delivery_latency>= 4000--latency in seconds

    and time>dateadd(mi,-10,dateadd(hh,-0,getdate()))

    and comments not like '%No replicated transactions are available%'

    Try this...

    Jared
    CE - Microsoft

  • January 11, 2012 at 10:12 am

    #1431952

    thanks alot!!! Really Apprecaite it!

Viewing 5 posts - 1 through 4 (of 4 total)

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