replication rate

How do I measure the replication rate between two SQL2K server?
Allen,
What type of replication are you using? Snapshot, merge, transactional?
I'll assume transactional. Have a look at these articles:
Transactional Replication Performance Tuning and Optimization
http://www.microsoft.com/technet/pro.../tranrepl.mspx
Also have a look at the SQLServer:Replication counters in performance
monitor.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Allen Iverson" wrote:
> How do I measure the replication rate between two SQL2K server?
>
|||For real-time reporting, in profiler there are a series of counters prefixed
with 'Replication' which can be used to monitor the delivered commands/sec,
read commands/sec etc.
If you want more of a reporting angle and are using merge replication, the
following query will tell you the number of inserts/updates/deletes over a
period of time made by the publisher and subscribers:
select publisher_insertcount, publisher_updatecount, publisher_deletecount,
subscriber_insertcount, subscriber_updatecount, subscriber_deletecount from
dbo.MSmerge_history
HTH,
Paul Ibison
|||Also have a look at this view MSdistribution_status in the distribution
database.
You can see how many commands are being delivered to subscribers, if you
check the distribution agent history in Enterprise Manager.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
""Allen Iverson"" <no_spam@.bk.com> wrote in message
news:O3z8%23XGSEHA.2936@.TK2MSFTNGP12.phx.gbl...
How do I measure the replication rate between two SQL2K server?