SQL Server Performance

How to log replication events in SQL Server 2000?

Discussion in 'Performance Tuning for SQL Server Replication' started by vijay78, Jun 17, 2007.

  1. vijay78 New Member

    How do I enable tracing for replication, and for distribution agents in specific, in SQL Server 2000. If I need to add any startup parameters, should I restart SQL Server as well. What is the path of the trace files generated? Please advise.
  2. satya Moderator

    What kind of events you need in the log?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. vijay78 New Member

    I need a high level trace to see if there are some issues with replicating tables/stored procs to my subscriber. I'd prefer to include all the available events. I haven't done this before and I really don't know what events I'm expected to see in there.
  4. vijay78 New Member

    Can someone guide me on this one please?

Share This Page