distribution 中一直在运行 waitfor delay @strdelaytime 语句-CSDN博客

distribution 中一直在运行 waitfor delay @strdelaytime 语句

Replication 自动创建来一个 Job:Replication monitoring refresher for distribution，这个Agent执行一个sp： dbo.sp_replmonitorrefreshjob ，在该SP中存在一个Loop，如下

create procedure sys.sp_replmonitorrefreshjob 
(
    @iterations tinyint = 0 -- 0 - run continuously, non 0 - run for specified iterations
    ,@profile bit = 0 -- for internal use - DO NOT DOCUMENT (remove this before release)
)
.....
while (1=1)
begin
--other commands--
--
-- wait for given delay
--
if (@profile = 1)
    raiserror('Waitfor delay %s', 10, 1, @strdelaytime)
waitfor delay @strdelaytime
end -- while (1=1)

为了有效监控Replication的运行，SQL Server Replication将性能数据缓存起来，周期性的刷新缓存。数据缓存能够减少查询，并且能够供多个User同时查询Replication的性能数据。dbo.sp_replmonitorrefreshjob 用于刷新缓存数据，刷新的周期（@strdelaytime）为4s 或 30s。

Microsoft SQL Server Replication Monitor is designed to efficiently monitor a large number of computers in a production system.The queries that Replication Monitor uses to perform calculations and gather data are cached and refreshed on a periodic basis. Caching reduces the number of queries and calculations required as you view different pages in Replication Monitor and allows monitoring to scale well for multiple users.

Cache refresh is handled by a SQL Server Agent job, the Replication monitoring refresher for distribution. The job runs continuously, but the cache refresh schedule is based on waiting a certain amount time after the previous refresh:

If there were agent history changes since the cache was last created, the wait time is the minimum of: 4 seconds; or the amount of time taken to create the previous cache.
If there were no agent history changes since the cache was last created (there could have been other changes), the wait time is the maximum of: 30 seconds; or the amount of time taken to create the previous cache.

参考doc：

Caching, Refresh, and Replication Monitor Performance

作者：悦光阴

出处： http://www.cnblogs.com/ljhdo/

本文版权归作者和博客园所有，欢迎转载，但未经作者同意，必须保留此段声明，且在文章页面醒目位置显示原文连接，否则保留追究法律责任的权利。

分类: TroubleShooting

本文转自悦光阴博客园博客，原文链接：http://www.cnblogs.com/ljhdo/p/5765056.html，如需转载请自行联系原作者