How to set HistoryVerboseLevel Profile for all Agent

Chris Skorlinski
Microsoft SQL Server Escalation Services

This is a follow up post to my article Using “Verbose history agent profile.” while troubleshooting Replication.

Using SQL Server Management Studio you can set a default profile for all Replication Agents.  In this walk through I’ll change ALL Merge Agents default to use the “Verbose History Agent Profile”.

In SSMS, right click the Replication folder and select Distributor Properties. Near the bottom of the dialog select “Profile Defaults”.

image

Select Merge Agent page, then select “Verbose history agent profile”.

image

This profile, similar to the default, has HistoryVerboseLevel = 3 to record detailed Merge history data in the MSmerge_history table in the Distribution database.  To apply this new profile setting to ALL Merge Agent select “Change Existing Agents” then click OK.

image

While troubleshooting Replication you may want to increase the “History Retention”. Increasing DETAIL and keeping longer history will grow your distribution database.

image

 

image