Hello, I have a simple query in a stored procedure that matches on a table of about 12,000 rows and 20 columns containing strings. The search is performed using conditional CONTAINS (). The execution of queries in development environment with SQL Server 2005 takes about 100-200ms for each row, while...

How does the Change Data Capture feature in SQL Server 2008 affect performance? Is there any recommendation in how to use it to avoid any performance issue?