I'd like to use the master..sysperfinfo table for monitoring replication. I thought I could use Select sysperfinfo.cntr_value
where object_name = 'SQLServer:Replication Agents'
and counter_name = 'Running' and
instance_name = 'Logreader'
to monitor the number of Logreader agents running (alert when cntr_value < total number of agents). However, when I check the value (2) it doesn't match the 16 LogReader Agents I see running in EM under Replication Monitor> Agents> Log Reader Agents.
What makes this more puzzling to me is that 2 weeks ago I looked at the cntr_value and it was equal to the number of running Log Reader Agents (16).
Internet and forum searches have not turned up anything that lead to any answers.
Thanks in advance for helping me to understand disparate values between the cntr_value (2)and actual number of running Log Reader agents.
Note: No SQL Server 2000 zone found, using MSSQL2k5