阮胜昌的博客-Linux&MySQL数据库运维

DBCC SQLPERF(LOGSPACE);


EXEC sys.sp_cdc_help_jobs;


SELECT
SUM(ps.used_page_count) * 8.0 / 1024 AS Total_CDC_Size_MB
FROM sys.dm_db_partition_stats ps
JOIN sys.tables t ON t.object_id = ps.object_id
WHERE t.schema_id = SCHEMA_ID('cdc');


SELECT
session_id,
start_time,
tran_count,
DATEDIFF(SECOND, last_commit_time, GETDATE()) AS current_latency_sec
FROM sys.dm_cdc_log_scan_sessions
ORDER BY start_time DESC;


检查日志扫描会话（判断 Capture 是否在干活）
SELECT TOP 5
    session_id,
    start_time,
    end_time,
    duration,
    empty_scan_count,
    log_record_count,
    error_count
FROM sys.dm_cdc_log_scan_sessions
ORDER BY session_id DESC;


查看CDC延迟时间：
SELECT
session_id,
start_time,
tran_count,
DATEDIFF(SECOND, last_commit_time, GETDATE()) AS current_latency_sec
FROM sys.dm_cdc_log_scan_sessions
ORDER BY start_time DESC;