SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Change Tracking CHANGE_RETENTION = 1 DAYS


Change Tracking CHANGE_RETENTION = 1 DAYS

Author
Message
RVO
RVO
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2446 Visits: 552
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 ?
Sue_H
Sue_H
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24961 Visits: 7470
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 Smile
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



sgmunson
sgmunson
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32630 Visits: 5185
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 Smile
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)
Smile Smile Smile
Health & Nutrition
RVO
RVO
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2446 Visits: 552
I changed it to 1 DAY
but all tracking data seems to stay there and keeps accumulating . . .
I expected a cleanup....?
Sue_H
Sue_H
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24961 Visits: 7470
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



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search