首页 > 代码库 > replication_较少延迟时间

replication_较少延迟时间

https://www.mssqltips.com/sqlservertip/3598/troubleshooting-transactional-replication-latency-issues-in-sql-server/

 

http://www.informit.com/articles/article.aspx?p=344817&seqNum=4

https://msdn.microsoft.com/en-us/library/ms151223.aspx

 

The second way to override the default values is to specify the new values within the job that runs the agent. For example, you could run the distribution agent with the following values:

-Publisher [publisher_server] 
-PublisherDB [pubs] 
-Distributor [distribution_server] 
-SubscriptionType 1 
-Subscriber [subscriber_server] 
-SubscriberSecurityMode 0 
-SubscriberLogin [my_login] 
-SubscriberEncryptedPassword [************] 
-SubscriberDB [pubs]  
-Continuous 
-MaxBcpThreads 5


replication_较少延迟时间