SLIDES from talk I gave on Troubleshooting Transactional Replication


“REPL TALK”

Chris Skorlinski
Microsoft SQL Server Escalation Services

I recently gave a talk to the Charlotte SQL Server Users group on Troubleshooting Transactional Replication.  This talk included an overview of Transactional Replication, troubleshooting technique, a few key “take a ways”. I though it might be helpful if I shared with everyone my PowerPoint slides. They are attached below as PDF document.

As these talks seem to go, I didn’t get to cover all my material. Therefore, I’m planning to eventually get all of my Replication Performance Troubleshooting Technique (Tran and  Merge) posted this blog.

Hope you find this information helpful as you work with Microsoft Replication.


Comments (1)

  1. Brad Chen says:

    hi, Chris,

     I like your blog very much.

    When I read page 13 of this slide:

    “Aggressive Cleanup” as soon as transactions are delivered (@immediate_sync=True]

    “Retention Cleanup” only older then Retention Period (@immediate_sync=False]

    is correct or mistype?

    Due to your another post

    blogs.msdn.com/…/how-replication-setting-immediate-sync-may-cause-transactional-replication-distribution-database-growth.aspx

    "immediate sync" = FALSE is aggressively.