sqlserver读取日志以及复制

首选，在事务日志中，到底有多少是需要复制的？使用以下命令，可以确定事务日志中被标志为复制的命令有多少。

USE test
GO
SELECT count(*) FROM ::fn_dblog(NULL, NULL) WHERE Description='REPLICATE'
GO

 

 

 https://blog.csdn.net/kk185800961/article/details/71158711

 

检查分发到订阅数据库的更新数据命令执行计划

SELECT TOP 25
  st.text, qp.query_plan,
    (qs.total_logical_reads/qs.execution_count) as avg_logical_reads,
    (qs.total_logical_writes/qs.execution_count) as avg_logical_writes,
    (qs.total_physical_reads/qs.execution_count) as avg_phys_reads,
  qs.*
FROM sys.dm_exec_query_stats as qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) as qp
WHERE st.text like '%sp_MSupd_dbo%'
ORDER BY qs.total_worker_time DESC
Go

　　

 https://www.cnblogs.com/kerrycode/p/4266646.html