Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 614
  • Last Modified:

Can I view Replication history logs?

SUMMARY

When using Merge Replication, how can I view a history of what was actually replicated? Although detail would be ideal, even a summary level (i.e. n rows replicated from table x, n rows from table y, etc.) would be very helpful.

FULL BACKGROUND

We have a pair of SQL Server 2000 databases that were designed, built and maintained by a vendor. They are kept in sync with Merge Replication scheduled to run once each minute. However, as far as I can tell although the databases have very low transaction volume (typically a few updates per minute), the replication performance is unbelievably slow -- each rep cycle takes about 7 minutes! Needlessly to say, this hugely impacts system usability, as even a best case a response takes 14 minutes for what should be a minute or two; worst case is 28 minutes.

Because the entire system is "owned" by the vendor, we have little access to the innards. It is not a total black box, but our access is fairly limited. Despite our serious performance problem, all we get is finger pointing between the vendor and our IT dept. I suspect some gross Replication misconfiguration, like maybe the vendor accidentally set it to do a Snapshot every minute rather than just the Merge.

From my reading of Replication tutorials, I know that logs are kept, but I don’t know if these logs are only temporary data (i.e. rows pending replicated) or persistent data that could shed light on what is going on behind the scenes.

Note that I am not trying to get you folks to try and diagnose our performance problem -- I am sure there are far too many variables for that, plus my knowledge and access are limited. All I really want to know is if there is some kind of replication history log I might be able to access.

I have limited knowledge of SQL Server and Replication. I was a VB/Sybase app developer for many years (controlled tables, indexes, views, and stored procedures), but was never an SA. A few years ago I also ran MSDE on my home PC, using Visual Studio DotNET for the SQL front end. My only knowledge of Replication is by reading a few tutorials on-line.


Thank you in advance,
parkerea
0
parkerea
Asked:
parkerea
1 Solution
 
Kevin3NFCommented:
Search Books Online for the term outputverboselevel  It is a parameter you can add to the 'Run Agent' step of the job that runs your merge agent.

Add these:

-output c:\whatever.txt -outputverboselevel 3

You will get detailed info of everything the agent does.

It does not overwrite, so be sure to turn it off when done.

Performance issues are best dealt with using SQL Profiler, not merge logs.

Hope that helps,

Kevin3NF
0
 
parkereaAuthor Commented:
Excellent -- thank you very much! Following your advice I found the appropriate article in the Support.Microsoft.Com knowledge base.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now