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.

We have SQL Server 2008 Merge Replication enabled, and I wanted to monitor any merge conflicts that arose. I setup a SQL Server Agent Alert following the instructions here. However, what I've found is that the Conflicts/Sec performance counter does not seem accurate at all. Every time the Merge Agent runs (~every minute), the counter reports over 2,000 conflicts! (I've verified this by running Performance Counter.) This can't be correct. Looking at the Replication Conflict Viewer we have 8 conflicts, and none in the last two hours.

So my question is, how accurate is this counter? Is there another counter I should be using?

EDIT: Just to prove I'm not crazy, here's a recent image of Performance Monitor showing over 4,000 conflicts!

(click for larger image)

share|improve this question
    
This problem was appearing on our development server, but never appeared on our production server, so I have to assume it was a bug/configuration problem/sunspot. –  GuyBehindtheGuy Oct 30 '09 at 17:18

1 Answer 1

up vote 0 down vote accepted

That would be the counter to monitor. What are your conflict resolution settings set to?

share|improve this answer
    
If I understand your question correctly, I'm using the default resolver on all articles. –  GuyBehindtheGuy Oct 26 '09 at 14:23
    
I'm also using row-level conflict detection on all articles. –  GuyBehindtheGuy Oct 27 '09 at 16:26
    
Could someone be running large updates on two servers at about the same time? The replication viewer should only be showing conflicts which need your attention, not all conflicts. If the SQL Server is able to resolve them it self you shouldn't be able to see them (if I remember correctly). –  mrdenny Oct 27 '09 at 18:47

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.