Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Long running CDC Capture Expand / Collapse
Author
Message
Posted Tuesday, April 23, 2013 5:57 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 01, 2014 5:00 PM
Points: 193, Visits: 621
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.
Post #1445732
Posted Wednesday, April 24, 2013 1:16 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:04 AM
Points: 116, Visits: 337
What's the size of your logfile?

Greetz
SQL Pizza



sometimes you dont see the pizza for the toppings...
seek and ya shall find...
Post #1445791
Posted Wednesday, April 24, 2013 3:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 01, 2014 5:00 PM
Points: 193, Visits: 621
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.
Post #1445826
Posted Wednesday, April 24, 2013 8:22 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:04 AM
Points: 116, Visits: 337
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
SQL Pizza



sometimes you dont see the pizza for the toppings...
seek and ya shall find...
Post #1446009
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse