Friday, March 9, 2012

How to find out how much data is synchonized

Hi Guys,
I would like to find out, on average, how much data is synchronized over
a period of time.
Is there a log or some other way for me to find that?
Thank you,
Maer
Historical data is purged by default every two days. You can examine the
last two days history by this
select * from distribution.dbo.MSdistribution_history
select * from distribution.dbo.MSmerge_history
These are commands and not bytes.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Maer" <maer@.auditleverage.com> wrote in message
news:ub%23X1%23QKGHA.140@.TK2MSFTNGP12.phx.gbl...
> Hi Guys,
> I would like to find out, on average, how much data is synchronized
> over a period of time.
> Is there a log or some other way for me to find that?
> Thank you,
> Maer
>
|||What kind of replication is this and what version of SQL Server are you using?
Are you looking to see how many rows are send across the wire?
Replication monitor is the place you should look for that kind of information.
SQL Server 2005 monitoring provides more information than 2000.
You can also use perfmon replication counters if you want to go that route
"Maer" wrote:

> Hi Guys,
> I would like to find out, on average, how much data is synchronized over
> a period of time.
> Is there a log or some other way for me to find that?
> Thank you,
> Maer
>
>
|||If this is merge replication, you can use the MSmerge_genhistory table to
calculate this.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Maer" <maer@.auditleverage.com> wrote in message
news:ub%23X1%23QKGHA.140@.TK2MSFTNGP12.phx.gbl...
> Hi Guys,
> I would like to find out, on average, how much data is synchronized
> over a period of time.
> Is there a log or some other way for me to find that?
> Thank you,
> Maer
>

No comments:

Post a Comment