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/prodtechnol/sql/2000/maintain/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?