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.

In This Section

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.

See Also

Concepts

Using Change Data

Other Resources

Overview of Change Data Capture

Configuring Change Data Capture