Other Software and Data

 View Only
Back to discussions
Expand all | Collapse all

Connect CDC - Azure SQL Worker Limits

  • 1.  Connect CDC - Azure SQL Worker Limits

    Posted 02-16-2023 16:29

    I am trying to synchronise a number of large tables from DB/400 to Azure SQL DB. These tables are just short of a billion rows each. 

    When I try to start the "copy phase" fails because it exceeds the worker limitations of Azure SQL.

    We have a v8 cores with 32 Gb of memory as a standard configuration.


    Can someone suggest a solution.



    ------------------------------
    Brian Green
    People's Choice Credit Union
    GREENWICH NSW
    ------------------------------