RE: CDC Growth and poor performance issues

SSC Guru

Points: 323504

July 1, 2013 at 6:20 am

ok, if you cannot remove records due to your audit requirements, i think it comes down to query tuning;

can you grab some execution plans, and see if any of the inserted into teh cdc tables might benefit from indexes, either on the main table, or maybe even the CDC tables themselves?(i've not bothered putting indexes on any of the automatically built cdc tables...they only receive inserts anyway).

I'm sure you are already looking at the usual suspects... SARGabile arguments, catch all queries, indexing.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!