Skip to content

sys-dm-change-feed-log-scan-sessions.md

Latest commit

 

History

History
67 lines (57 loc) · 5.59 KB

sys-dm-change-feed-log-scan-sessions.md

File metadata and controls

67 lines (57 loc) · 5.59 KB
title sys.dm_change_feed_log_scan_sessions (Transact-SQL)
description sys.dm_change_feed_log_scan_sessions (Transact-SQL) shows activity for the Azure Synapse Link or Fabric Mirrored Database feature.
author WilliamDAssafMSFT
ms.author wiassaf
ms.reviewer imotiwala, ajayj
ms.date 05/19/2025
ms.service fabric
ms.subservice system-objects
ms.topic reference
ms.custom
ignite-2025
f1_keywords
sys.dm_change_feed_log_scan_sessions_TSQL
sys.dm_change_feed_log_scan_sessions
dm_change_feed_log_scan_sessions_TSQL
dm_change_feed_log_scan_sessions
helpviewer_keywords
sys.dm_change_feed_log_scan_sessions dynamic management view
dev_langs
TSQL
monikerRange >=sql-server-ver16 || =azuresqldb-current || =azuresqldb-mi-current || =fabric || =fabric-sqldb || =azure-sqldw-latest

sys.dm_change_feed_log_scan_sessions (Transact-SQL)

[!INCLUDE sqlserver2022-asdb-asdbmi-asa-fabricmirroredsqldb-fabricsqldb]

Returns activity from the SQL change feed.

This dynamic management view is used for:

Column name Data type Description
session_id int ID of the session.

0 = the data returned in this row is an aggregate of all sessions since the instance of [!INCLUDE ssNoVersion] was last started.
start_time datetime Time the session began.

When session_id = 0, the time aggregated data collection began.
end_time datetime Time the session ended.

NULL = session is active.
When session_id = 0, the time the last session ended.
duration int The duration (in seconds) of the session.

0 = the session does not contain change data capture transactions.

When session_id = 0, the sum of the duration (in seconds) of all sessions with change feed transactions.
batch_processing_phase nvarchar(200) The stage of scan reached in a particular log scan session. The following are the currently implemented phases:
1: Reading configuration
2: First scan, building hash table
3: Second scan
4: Second scan
5: Second scan
6: Schema versioning
7: Last scan, publish and commit.
8: Done
error_count int Number of errors encountered.

When session_id = 0, the total number of errors in all sessions.
batch_start_lsn nvarchar(23) Starting LSN for the session.

When session_id = 0, the starting LSN for the last session.
currently_processed_lsn nvarchar(23) Current LSN being scanned.

When session_id = 0, the current LSN is 0.
batch_end_lsn nvarchar(23) Ending LSN for the session.

NULL = session is active.

When session_id = 0, the ending LSN for the last session.
tran_count bigint Number of change data capture transactions processed. This counter is populated in batch_processing_phase 2.

When session_id = 0, the number of processed transactions in all sessions.
currently_processed_commit_lsn nvarchar(23) LSN of the last commit log record processed.

When session_id = 0, the last commit log record LSN for any session.
currently_processed_commit_time datetime Time the last commit log record was processed.

When session_id = 0, the time the last commit log record for any session.
log_record_count bigint Number of log records scanned.

When session_id = 0, number of records scanned for all sessions.
schema_change_count int Number of data definition language (DDL) operations detected. This counter is populated in batch_processing_phase 6.

When session_id = 0, the number of DDL operations processed in all sessions.
command_count bigint Number of commands processed.

When session_id = 0, the number of commands processed in all sessions.
latency int The difference, in seconds, between end_time and currently_processed_commit_time, in the session. This counter is populated at the end of batch_processing_phase 7.

When session_id = 0, the last nonzero latency value recorded by a session.
empty_scan_count int Number of consecutive sessions that contained no captured transactions.
failed_sessions_count int Number of sessions that failed.

Permissions

Requires VIEW DATABASE STATE or VIEW DATABASE PERFORMANCE STATE permission to query the sys.dm_change_feed_log_scan_sessions dynamic management view. For more information about permissions on dynamic management views, see Dynamic Management Views and Functions.

In Fabric SQL database, a user must be granted VIEW DATABASE STATE in the database to query this DMV. Or, a member of any role the Fabric workspace can query this DMV.

Related content