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…