Monitoring Replication (SQL Server Compact Edition)
You can monitor Subscribers on the computer that is running Microsoft SQL Server by using the Replication Monitor. You can also use the SQL Server 2005 Compact Edition (SQL Server Compact Edition) Server Agent statistics page to provide detailed information about the agent. For more information, see "Monitoring Replication with Replication Monitor" in the SQL Server Books Online.
Using Replication Monitor
You use Replication Monitor to examine the status of subscriptions. In SQL Server 2000, Replication Monitor is part of Enterprise Manager. In SQL Server 2005, the Replication Monitor is a separate tool. It can be accessed through SQL Server Management Studio.
Any time an automatic resynchronization occurs, it is considered a separate synchronization to SQL Server. Therefore, SQL Replication Monitor will have a unique entry for each synchronization. On the SQL Server Compact Edition subscriber, the values of the PublisherChanges, SubscriberChanges, PublisherConflicts, and SubscriberConflicts properties of the SqlCeReplication class is summed up and the total of all synchronizations is provided on the return of the last synchronization.
For more information about opening Replication Monitor, see How to: Start the Replication Monitor.
Naming of SQL Server Compact Edition Clients in Replication Monitor
Unlike SQL Server Subscribers on a network, there is no guarantee that SQL Server Compact Edition Subscribers will have unique names. Therefore, to display individual clients in the Replication Monitor, a unique name is created based on the subscriber GUID of each device.
SQL Server Compact Edition Subscribers are given different names in Replication Monitor, depending on whether the Publisher is SQL Server 2000 or SQL Server 2005:
- Publisher is SQL Server 2000
For SQL Server Compact Edition subscribers listed in the SQL Server 2000 Enterprise Manager Replication Monitor, the Merge Agent subscription column is formatted as subscribername:-agentid. The subscribername and the agentid can be used to find the Subscriber ID (GUID) in the msmerge_agents system table in the distribution database.
- Publisher is SQL Server 2005
For SQL Server Compact Edition Subscribers listed in the SQL Server 2005 Replication Monitor, the subscription column is formatted as subscriber – replnickname:db_name. The replnickname can be used to find the subscriber row in the sysmergesubscriptions system table in the Publisher database.