Monitoring Replication

PATROL for Microsoft SQL Server automatically detects and monitors replication feature when it enabled on monitored SQL Server.

The following monitor types are related to Replication feature:

• MS-SQL-Server-Replication-MSSQL_SERVER_REPLICATIONS_CONTAINER
• MS-SQL-Server-Subscribers-MSSQL_SERVER_REPLICATION_SUBSCRIBERS_CONTAINER
• MS-SQL-Server-Replication-Subscriber-MSSQL_SERVER_REPLICATION_SUBSCRIBER
• MS-SQL-Server-Publishers-MSSQL_SERVER_REPLICATION_PUBLISHERS_CONTAINER
• MS-SQL-Server-Replication-Publisher-MSSQL_SERVER_REPLICATION_PUBLISHER
• MS SQL Server Perfmon Replication Agents
• MS SQL Server Perfmon Replication Dist
• MS SQL Server Perfmon Replication Logreader
• MS SQL Server Perfmon Replication Merge
• MS SQL Server Perfmon Replication Snapshot

Permissions

Login account which used for monitoring must be a member in the sysadmin fixed server role or the db_owner fixed database role.

For more information about Replication, see

• https://msdn.microsoft.com/en-us/library/ms174364.aspx

• https://msdn.microsoft.com/en-us/library/ms151754.aspx