"pardhiveswar via SQLMonster.com" <u8956@uwe> wrote in message
news:603165cfa76d7@uwe...
> Hi
>
> I am sqlserver dba.recently in our company we have a big issue in
> replication the data is not moving from source to destination finally i
> made
> it move with the help of sql monster articles now everyone is happy but
> when
> i double click distributor agent which is under
>
> Replication monitors--->publishers---->server---->publication.
>
> when i double-click publication it shows the 3 rows (snapshot
> agent,logreader
> agent,distributor agent)
>
> when i double-click distributor agent i noticed that last run status
> (startdate),next run date,duration,latency,#trans,#cmds are not refreshing
> statistics for ex: duration is showing 15;20;22 (but data is moving from
> source to destination) is there a way that i can see the results
> acurately.
> even from windows performance monitor didn't help the statistics are same.
> then i started looking at the jobs to see the view history shows nothing
> in
> repl-distribution. except (cancelled)
>
>
> i used sp_help_job statistics are not updated.
>
> I believe i can find the solution for this(here)
>
> Thanks,
> Pardhi
>
> --
> Message posted via http://www.sqlmonster.com

Hilary Cotter wrote:
>It possible that you are not automatically refreshing your replication
>monitor. Close down EM, and then bring it up again. This will force a
>refresh.
>
>> Hi
>>
>[quoted text clipped - 27 lines]
>> Thanks,
>> Pardhi