Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am trying to get the statistics from my 2008 sql server replication SQL Server: Replication Dist. statistics, but no data is coming even while replication is in full swing.

I am using SQL 2008 peer-to-peer replication and use a load test on our web site to generate the load on the database that is replicated.

There are no errors coming from Replication Monitor and the Latency on the publication is showing and changes between 0 and 3 seconds during the test.

We are monitoring the statistics for the distributor at both ends of the peer-to-peer replication.

Is there something I need to do to get SQL to start publishing the stats?

note: I have added a second publication using a snapshot model and that causes stats to be generated. Does SQL not record latency for peer-to-peer?

share|improve this question
    
Are you monitoring the publisher, the subscriber or the distributor? –  Remus Rusanu Jul 21 '10 at 0:03
    
Peer to peer replication, monitoring on both nodes (i.e. at publisher and subscriber). The distributor is the item measured by the statistic. –  Nat Jul 21 '10 at 0:39

2 Answers 2

is the server running as a default instance? if not then look for the perfmon object that is in the form of MSSQL$instancename:Replication Dist.

share|improve this answer

Each subscription creates it's own group of instances under the perfmon category. Be aware that SQL keeps instances of previously deleted subscriptions, so make sure you are measuring the correct instance, especially when tearing down and recreating subscriptions.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.