"Jenny" <jyu@iseoptions.com> wrote in message
news:353401c3fd57$606d6530$a301280a@phx.gbl...
> Hi,
>
> Our production database configured transactional
> replication with push (it is real-time database). During
> the day, once data loading to primary site (publisher), it
> took 1 minute push data to secondary site (subscriber).
>
> Is the way to reduce the latency from 1 minute to 1 second?
>
> Regards,
> Jenny
>

>-----Original Message-----
>the best you can do is to expand replication monitor,
expand replication
>agents, expand your agents folder, right click on your
distribution agent
>and then select agent property, select the steps tab, and
then select run
>agent. Click edit command and hit the space bar and then
at the end of the
>string type -pollinginterval 1
>
>Do the same for your logreader agent
>
>This will drop your latency considerable - to within 1-2
s.
>
>
>"Jenny" <jyu@iseoptions.com> wrote in message
>news:353401c3fd57$606d6530$a301280a@phx.gbl...
>> Hi,
>>
>> Our production database configured transactional
>> replication with push (it is real-time database). During
>> the day, once data loading to primary site (publisher),
it
>> took 1 minute push data to secondary site (subscriber).
>>
>> Is the way to reduce the latency from 1 minute to 1
second?
>>
>> Regards,
>> Jenny
>>
>
>
>.