Administering and Monitoring Change Data Capture

To administer and monitor change data capture, you must keep track of various aspects. This section provides information about change data capture Agent Jobs and data types.

The topics in this section describe how to administer change data capture.

Capture Job

Describes the capture job and its parameters.

Cleanup Job

Describes the cleanup job.

Monitoring the Change Data Capture Process

Describes how to use dynamic management views and the SQL Server data collector to monitor change data capture.

Data Type Considerations for Change Data Capture

Describes the behavior and limitations for several column types.

Change Data Capture and Other SQL Server Features

Describes how change data capture interacts with transactional replication, database mirroring, and other features.