sqlserver读取日志

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

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

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