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?

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?

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/pr...n/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?

Replication issues between SQL mobile and SQL2k?

I meant to cross-post this over here, but not having much response in SQLCE
forum ...
I'm in the process of a 'forced' upgrade (my client bought newer PocketPCs).
Soooo .. what I would like to know is whether there are any issues
connecting SQL Mobile to SQL 2000 for replication. Currently, replication
works "as advertised" between SQLCE and SQL2000 (enterprise).
The models seem quite symmetrical. I have not had any problems ...yet.
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
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:eQT3Y76BGHA.1032@.TK2MSFTNGP11.phx.gbl...
>I meant to cross-post this over here, but not having much response in SQLCE
>forum ...
> I'm in the process of a 'forced' upgrade (my client bought newer
> PocketPCs).
> Soooo .. what I would like to know is whether there are any issues
> connecting SQL Mobile to SQL 2000 for replication. Currently, replication
> works "as advertised" between SQLCE and SQL2000 (enterprise).
>
|||We're using this setup in a production environment and so far things work in
a similar fashion to our SQL CE to SQL 2000 replication. And...we get the
added benefit of background or async replication, which is very nice.
- will
"Earl" wrote:

> I meant to cross-post this over here, but not having much response in SQLCE
> forum ...
> I'm in the process of a 'forced' upgrade (my client bought newer PocketPCs).
> Soooo .. what I would like to know is whether there are any issues
> connecting SQL Mobile to SQL 2000 for replication. Currently, replication
> works "as advertised" between SQLCE and SQL2000 (enterprise).
>
>