Microsoft’s Steffen Krause has written an excellent whitepaper on Tuning the Performance of Change Data Capture in SQL Server 2008, that I technically reviewed, and it was published late last year. To get an overview of Change Data Capture (CDC) before reading the whitepaper, see the TechNet Magazine article I wrote for the November issue, titled SQL Server 2008: Tracking Changes in Your Enterprise Database. The new whitepaper covers:
Configuration of sys.sp_cdc_enable_table parameters
Configuration of the CDC capture job
Using Extended Events to determine the performance and characteristics of CDC
Influence of CDC scan job parameters on CDC performance
Influence of workload characteristics on CDC performance
Influence of sys.sp_cdc_enable_table parameters on CDC performance
CDC cleanup job considerations
Transaction log file considerations
Check it out at http://msdn.microsoft.com/en-us/library/dd266396(v=sql.100).aspx.
5 thoughts on “New whitepaper on tuning Change Data Capture performance”
Is this link “http://msdn.microsoft.com/en-us/library/dd266396.aspx” still working. I am not able to access the article
It’s working for me.
Full stop is included in the URL link hence it doesn’t work if clicked.
It’s not – it’s that they moved the whitepaper to a new location. I’ve updated the link.
I have the Change Data Capture in my large environment and as you mentioned in your article… I´m facing disk space issues with the log files.
I was considering change my data track from CDC to Change track.
This e-mail is just to tell you it’s a great article and will be very usefull to open my mind about other alternatives…
Thank you so much…