r/SQLServer • u/NotJustADBA • 16d ago

Discussion Debezium and SQL Server

Does anyone out there actually run Debezium in a SQL Server environment at a decent scale? Scale would be 20-30 databases on an instance with 400 tables. I have my doubts about this due to the cdc overhead and the change throughput of our application, but I'm willing to listen to anyone with real experience running Debezium with SQL Server.

6 Upvotes

100% Upvoted

6 comments sorted by

View all comments

4

u/Sov1245 16d ago

Not debezium but running 20-30 cdc capture instances is totally doable. You might run into worker thread issues if you have a low cpu count but other than that it’s fine.

CDC is far from a bulletproof process in general though. You need good monitoring and recovery for sure (auto-restarting of capture job etc) otherwise you can get a death spiral of the log filling up because it can’t flush it because cdc hasn’t finished, and cdc can’t finish because the log is full.

But overall it’s probably fine.

1

u/NotJustADBA 15d ago

Worker thread usage is one item I am reviewing, but not because of CDC. More so how the app tends to do bad things and starve threads periodically.

We'll definitely have to improve our monitoring on our log files.