Repl. Pending Xacts / sys.dm_os_performance_counters

• Peter Schofield

  Ten Centuries

  Points: 1334

  More actions

  April 6, 2009 at 9:35 am

  #384297

  Hi,

  Using this DMV, I've got two user databases (value=983691740) and the system database Model showing a high value for Repl. Pending Xacts - even though the user databases are not involved in Replication. It seems a bit unusual - would there be a performance hit for this?

  I've looked at other servers, and the value for user databases not involved in replication is 0.

  Thanks,

  Peter

• Youri S. Pikulin

  Old Hand

  Points: 315

  More actions

  June 9, 2009 at 3:34 am

  #1006535

  I have the same eeh... problem. This counter is extremely high for some databases on some servers, even never used replication.