Find out how much data was replicated

25 Mar 2005 3:05 PM

Osk

Hi

I use SQL Servers 2000 SP3 on Windows 2000 Advanced Server
SP4. I've set up a transactional replication w/o updating
between two servers, one of which is a publisher and the
other is a distributor/pull-subscriber. I wonder if SQL
Server has means of finding out how much data was
replicated (i.e. sent to the subscriber), say, during the
day. If it hasn't, are there any third-party tools, which
would allow me to do this?

--
Many thanks,
Osk

25 Mar 2005 6:57 PM

Jeff Robinson

check the replication monitor in EM it will display a "gross" level of
information processed by article published.

Show quoteHide quote

"Osk" wrote:

> Hi
>
> I use SQL Servers 2000 SP3 on Windows 2000 Advanced Server
> SP4. I've set up a transactional replication w/o updating
> between two servers, one of which is a publisher and the
> other is a distributor/pull-subscriber. I wonder if SQL
> Server has means of finding out how much data was
> replicated (i.e. sent to the subscriber), say, during the
> day. If it hasn't, are there any third-party tools, which
> would allow me to do this?
>
> --
> Many thanks,
> Osk
>
>

28 Mar 2005 5:25 AM

Osk

Hi

What do you mean by "gross" level? I need to know how much
bytes were delivered to the subscriber during a time interval.

--
Thanks,
Osk

>-----Original Message-----
>check the replication monitor in EM it will display a

"gross" level of
Show quoteHide quote

>information processed by article published.
>
>"Osk" wrote:
>
>> Hi
>>
>> I use SQL Servers 2000 SP3 on Windows 2000 Advanced Server
>> SP4. I've set up a transactional replication w/o updating
>> between two servers, one of which is a publisher and the
>> other is a distributor/pull-subscriber. I wonder if SQL
>> Server has means of finding out how much data was
>> replicated (i.e. sent to the subscriber), say, during the
>> day. If it hasn't, are there any third-party tools, which
>> would allow me to do this?
>>
>> --
>> Many thanks,
>> Osk
>>
>>
>.
>