April 23, 2013 at 5:57 pm
Hi All,
I have a major issue now in my SQL Instance where in I my CDC capture is 48 behind my ETL on base tables.
CDC retention is 8 days. we have 8 million updates and 2 million inserts every 4 hours on the database.
How can i reduce the latency. Please help.
April 24, 2013 at 1:16 am
What's the size of your logfile?
Greetz
Query Shepherd
April 24, 2013 at 3:49 am
Its 300 GB as of now, but we have 2 million updates happenning every 4 hours on the tables.
can you help me understand this DMV better. I'm getting confused with Books online
1) what exactly does log_record_Count in sys.dm_cdc_log_scan_sessions means?
2) How can I get the # of records processed in CT Table per CDC session.
April 24, 2013 at 8:22 am
That's important...the bigger your logfile gets the slower gets CDC. Try to minimize your logfile and keep it small through logfilebackups every f.e. 15 minutes!
@1) Number of log records scanned. When session_id = 0, number of records scanned for all sessions.
@2) I don't know...why you wanna know this? Maybe someone else could help...
Greetz
Query Shepherd
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply