sql server replication: I have some publications with many subscriptions as part of transactional
replication.
Why cant i see all those distribution agents in the perfmon counters for SQL
Server: Replication Dist object under instances ? I see just 2 out of the 20
or more that we have . I am using SQL server 2000

They are all push subscriptions running on the distributor.

[quoted text, click to view]

I think you'll only see agents for push subscriptions running on the
distributor... Not for pull and not for remotely activacted push
subscriptions.
[quoted text, click to view]

Hi Fatima,
You are probably running into a bug that has been filed on this issue
recently and is currently being investigated. You can try the following

1.Restart the SQL Server and SQL Server Agent services on the
publisher/distributor.
2.After the restart, check if the all the distribution agent instances are
listed. If not note down what was missing.
3. If all the distribution agents were not listed, connect to the
publisher/distributor with Query Analyzer and execute the following query:
use master
go
exec sp_MSload_replication_status
4.Open Perfmon and check if all the distribution agent instances are
listed.

Hope that helps.
Thank you.
Ramu.


This posting is provided AS IS with no warranties, and confers no rights.
Are you secure For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
httpwww.microsoft.com/security .