Share via

Request for Insights on Enabling CDC with ADR on Azure SQL Managed Instance

Satya Varaprasad 1 Reputation point
2025-01-10T06:30:36.1366667+00:00

I am reaching out to check if anyone has prior experience or insights on enabling and managing these features together in Azure SQL Managed Instance.

Specifically, we are interested in understanding:

• Any challenges or considerations when enabling CDC alongside ADR.

• Performance impacts or potential conflicts between these features.

• Best practices or lessons learned during implementation.

If you have worked on a similar setup or have resources that could assist, I would greatly appreciate your guidance.

Looking forward to hearing from you!

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. NIKHILA NETHIKUNTA 4,020 Reputation points Microsoft Vendor
    2025-01-10T15:50:20.24+00:00

    @Satya Varaprasad
    Thank you for the question and for using Microsoft Q&A platform.

    As per my understanding, you are trying to gain some insights on enabling and managing Change Data Capture (CDC) alongside Accelerated Database Recovery (ADR) in Azure SQL Managed Instance.

    1. Currently, enabling both CDC and ADR simultaneously isn't supported in SQL Server. When CDC is enabled, the aggressive log truncation feature of ADR is disabled because the CDC scan accesses the database transaction log.
      User's image
    2. Since ADR's aggressive log truncation is disabled when CDC is enabled, this can lead to increased transaction log size and potentially impact performance.

    3)Both features might need intensive resources. CDC involves scanning the transaction log and maintaining change tables, while ADR involves maintaining a persistent version store in the database. This can lead to increased CPU and I/O usage.

    1. When implementing CDC and ADR together, it's important to carefully consider your recovery objectives and ensure that you have adequate storage and resources to support both features. Additionally, it's a good idea to regularly monitor your database performance and adjust your configuration as needed to ensure optimal performance.

    For more information, please refer to the below document:
    https://zcusa.951200.xyz/en-us/sql/relational-databases/track-changes/known-issues-and-errors-change-data-capture?view=sql-server-ver16

    Hope this helps. Do let us know if you have any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.