transactional replication performance -- packet size and buffer nu

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: George (George_at_discussions.microsoft.com)
Date: 01/23/05 

Date: Sat, 22 Jan 2005 20:57:02 -0800

I have replication servers accross the ocean but the data volumn is so high
that on subscriber site the data is always delayed.

I have followed with BOL and changed the replication parameters like -b -c
-packet -buffer -OutputVerboseLevel etc but not enough.

I have traced on network, the network bandwidth is much higher than
replication currently using;

and checked with sp_who2 the replication connection is always waiting for
command;

I'm just wondering what is the best buffer size and packet size. when I
setup packet size to 32000, the replication speed beomes much faster,
meanwhile when I change buffers to 8 it does not help too much.

so what is the better setting for packet size and buffer number? how large
is a single buffer size? is 16 better than 8 when packet size is 32000?

Thanks

Relevant Pages

  • Re: Severe performance issues with replication.
    ... Perfomon counters: SQL: BUffer Manager ... BUffer Cache Hit Ratio ... Yes it is on the same server as the publisher. ... find anything wrong but since we can live without the dev replication ...
    (microsoft.public.sqlserver.replication)
  • Re: Delphi or DNA?
    ... 'junk-DNA' has been shown to be ... No, it hasn't been shown to do anything in replication, except act as a ... buffer against the loss at the ends of the DNA strands. ...
    (borland.public.delphi.non-technical)
  • Re: Active Directory Domian Controllers
    ... replication occurs nearly real-time as changes occur - the DC ... where the change occured will wait 15 seconds as a "buffer", ... Responses provided as-is; ...
    (microsoft.public.windows.server.active_directory)
  • Re: LDAP/AD Problems Related to WAN?
    ... If a packet size larger then the MTU is sent, no responses will be received. ... It seems that the second DC at the remote site cannot communicate over the ... the new DC is getting replication errors for the ... while I was in the registry I also upped the Diagnostics levels to 5 for RPC ...
    (microsoft.public.windows.server.active_directory)
  • RE: AD Replication problem
    ... The packet size does not limit the AD replication. ... Maximal Transmission Unit (MTU), which lives between second and third OSI ... > I start to ping sites and getting errors when packet reaches beyond certain ...
    (microsoft.public.windows.server.active_directory)