New whitepaper on tuning Change Data Capture performance

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

  1. Is this link “http://msdn.microsoft.com/en-us/library/dd266396.aspx” still working. I am not able to access the article

  2. 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…

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.