Link to home
Start Free TrialLog in
Avatar of saratcm
saratcmFlag for India

asked on

Long delay b/w subscriber & Publisher

Hi All,
I have a case in trnsactional replication,
Our subscribers are getting updated with a long delay from publisher.
So what should I do to reduce the delay b/w publisher n subscriber?
ASKER CERTIFIED SOLUTION
Avatar of David Todd
David Todd
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of saratcm

ASKER

Hi TAB8,
U mean dropping indexes on subscriber side?
will it work?
What is meant by increasing batch size?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of saratcm

ASKER

Thanks Guys.