| Aspect | Details |
|---|---|
| The number of tracked CDC-enabled tables | ... |
| Frequency of changes in the tracked tables | ... |
| Space available in the source database | Notice that CDC artifacts (e.g. CT tables, cdc_jobs etc.) are stored in the same database |
| Whether the database is single or pooled. | In elastic pools, in addition to considering the number of tables that have CDC enabled, pay attention to the number of databases those tables belong to |
| Databases in a pool share resources among them (such as disk space), so enabling CDC on multiple databases runs the risk of reaching the max size of the elastic pool disk size | |
| Monitor resources such as CPU, memory and log throughput |
- Default: 52494800 (100 years)
| Article Title | Link |
|---|---|
| What is change data capture (CDC)? | link |
| sys.sp_cdc_change_job (Transact-SQL) | link |
| Which are the downsides of not deleting the CDC records in change tables? | link |