We have a major Production Performance Hit on CDC Latency.
CDC latency : 48 hours. (2 days ago was almost real time: )
log file size: 300 GB
DB Size: 1.5 TB
VLF Count: 5209
SAN type: VMAX(Filber Channel)
As of now. the CDC_Commit_Time has hardly any movement. We ar ekinda stuck. If I Kill the SPID now, the Open Tran will take atleast 30 - 45 to roll back.
MaxTrans was 500 till this morning. I Bumped it to. 5000.
MaxScans was 10 till this morning. I bumped it to 100.
How can i get out of it. Please suggest me. We are kinda stuck in a quick sand.
Regards JakDBA Please Mark this as Answered if this solves your issue or satisfied with the response.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?