Post reply

cdc log growth

  • October 14, 2014 at 9:39 am

    #294207

    All,

    I have cdc enabled on a Sql Server 2012 database that is a primary db in transactional replication and the primary in a availability group. The log file is a little over 95 GB, a historic high. I have the cdc._cleanup job running every 5 minutes. We have a weekly full backup, nightly differentials, and transaction logs that run every 15 minutes. The default retention time for cdc is still set for 72 hours. I am not able to shrink the log. Any suggestions?

    Thanks,

    DK

  • October 14, 2014 at 2:28 pm

    #1752318

    Did you check dbcc sqlperf('logspace ') ? what amount of log is filled

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • October 16, 2014 at 7:45 am

    #1752863

    Thanks for the reply. It is 92% full.

  • October 16, 2014 at 7:59 am

    #1752867

    Sounds like the cleanup job is not running properly.

    You should also check your cdc capture job and make sure it is running without error as well.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • October 16, 2014 at 12:57 pm

    #1752946

    SELECT name, log_reuse_wait_desc FROM sys.databases?

    Alex Suprun

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply