October 11, 2017 at 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 ?
October 11, 2017 at 5:11 pm
RVO - Wednesday, October 11, 2017 3:40 PMWe 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
October 12, 2017 at 12:13 pm
Sue_H - Wednesday, October 11, 2017 5:11 PMRVO - Wednesday, October 11, 2017 3:40 PMWe 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)
October 13, 2017 at 12:43 pm
I changed it to 1 DAY
but all tracking data seems to stay there and keeps accumulating . . .
I expected a cleanup....?
October 13, 2017 at 2:17 pm
RVO - Friday, October 13, 2017 12:43 PMI 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