New rows contain pointer to the old row in the version store area in tempdb. Older rows contain pointers to even older versions. SO , my question is , how many older versions can the version store hold? Is there a limit?
New rows contain pointer to the old row in the version store area in tempdb. Older rows contain pointers to even older versions. SO , my question is , how many older versions can the version store hold? Is there a limit?
Not really a limit - it will keep what is needed. The background version store cleanup runs about every minute and removes versions no longer needed so it's not keeping all versions forever.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply