Decrease Replication Latency By Configuring Batches

This lesson walks through configuring the Microsoft SQL Server Distribution Agent to move transactions using Batch Stored Procedures for faster throughput.

15 years as Microsoft SQL Server Escalation Engineer specializing in configuration, performance tuninng, and troubleshooting Microsoft SQL Server Replication.

Joshua Clausen on 2/24/2010

Well-stated.

A36061F4FA on 2/24/2010

It is always good to learn more about replication.

Mark Weichman on 2/24/2010

great stuff!!

Moklesur Rahman on 2/24/2010

Very useful for me.

Moklesur Rahman on 2/24/2010

Very useful for me.

Johnny Wild on 2/24/2010

Is the stored procs automatically generated? I must be missing something here. What happened to the T-SQL statements, etc?

erick on 2/26/2010

Can you please create a follow up this video. Thank you

Paul Kirkham on 3/2/2010

Very poor screen resolution blurry

Emine Dekkar on 3/2/2010

good to know

Team FAB on 3/3/2010

It was difficult to read the detail on the screen when it wasn't zoomed.

0F746131B8 on 4/8/2010

I don't get this video. It talks about batching transactions over replication. By switching the replication to use a sproc it is still going to issue the transaction on the subscriber 1 row at a time just via a sproc vs a tsql cmd. To verify this just look at the sprocs that are created by replication on subscriber.

Sekhar Reddy on 5/23/2010

Very useful and quick Tip. Good Demo.

Ravi Raj on 6/27/2010

good one

Ravi Raj on 6/27/2010

good one

erick on 8/18/2010

love it!