Change Tracking CHANGE_RETENTION = 1 DAYS

  • We are using Change Tracking with CHANGE_RETENTION = 5 DAYS . . 
    ALTER DATABASE DTJX0_CSI
    SET CHANGE_TRACKING = ON
    (CHANGE_RETENTION = 5 DAYS, AUTO_CLEANUP = ON)


    If we switch to
    CHANGE_RETENTION = 1 DAYS
    when that day starts? 12:00 AM ?

  • RVO - Wednesday, October 11, 2017 3:40 PM

    We are using Change Tracking with CHANGE_RETENTION = 5 DAYS . . 
    ALTER DATABASE DTJX0_CSI
    SET CHANGE_TRACKING = ON
    (CHANGE_RETENTION = 5 DAYS, AUTO_CLEANUP = ON)


    If we switch to
    CHANGE_RETENTION = 1 DAYS
    when that day starts? 12:00 AM ?

    I remember looking for that before and never did find anything. 
    Just my thinking on it was the retention is the minimum time retained. So if a change happened at 11:50 pm, it would be way too problematic if it was deleted at 12:01 am. I would guess 1 day would be the same as 24 hours since it needs to be retained at least one day. And even 11:50 am would be half a day, not a day. But I never did find anything official so that's what I made up 🙂
    I did notice that things can end up in there longer than the retention period - not real bad but things aren't deleted right when meeting the retention period even though that cleanup process runs every 30 mins. Saw that when I was trying to figure out the same thing.

    Sue

  • Sue_H - Wednesday, October 11, 2017 5:11 PM

    RVO - Wednesday, October 11, 2017 3:40 PM

    We are using Change Tracking with CHANGE_RETENTION = 5 DAYS . . 
    ALTER DATABASE DTJX0_CSI
    SET CHANGE_TRACKING = ON
    (CHANGE_RETENTION = 5 DAYS, AUTO_CLEANUP = ON)


    If we switch to
    CHANGE_RETENTION = 1 DAYS
    when that day starts? 12:00 AM ?

    I remember looking for that before and never did find anything. 
    Just my thinking on it was the retention is the minimum time retained. So if a change happened at 11:50 pm, it would be way too problematic if it was deleted at 12:01 am. I would guess 1 day would be the same as 24 hours since it needs to be retained at least one day. And even 11:50 am would be half a day, not a day. But I never did find anything official so that's what I made up 🙂
    I did notice that things can end up in there longer than the retention period - not real bad but things aren't deleted right when meeting the retention period even though that cleanup process runs every 30 mins. Saw that when I was trying to figure out the same thing.

    Sue

    I would have expected it to mean from the date/time of any given change, and removed at the next cleanup thereafter.  However, that's entirely a guess based on what appears to be logical reasoning that says that something deleted at 11:59 PM would have to at least be retained until the following day at that exact same time, given a 1 day retention period.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • I changed it to 1 DAY
    but all tracking data seems to stay there and keeps accumulating . . .
    I expected a cleanup....?

  • RVO - Friday, October 13, 2017 12:43 PM

    I changed it to 1 DAY
    but all tracking data seems to stay there and keeps accumulating . . .
    I expected a cleanup....?

    Give it a bit and see. From what I remember, one day deleted anywhere between 24 and 48 hours.
    That's what I was alluding to in my earlier post.

    Sue

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

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