SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags SQL Server 2008, Change Data Capture (CDC), Performance Tuning Rss

   Items 1 to 1 of 1   

Tuning the Performance of Change Data Capture in SQL Server 2008

Change data capture is a new feature in SQL Server 2008 that provides an easy way to capture changes to data in a set of database tables so these changes can be transferred to a second system like a data warehouse. This document provides guidance on how to configure change data capture parameters to maximize data capture performance while minimizing the performance impact on the production workload. The scope of this document is limited to the capture of change data and the cleanup process. Querying the changed data is out of scope for this white paper.  Read more...
Rating:  Rate this |   Briefcase | 2,425 reads
   Items 1 to 1 of 1