• coolchaitu - Saturday, April 21, 2018 8:17 AM

    Good Morning Experts,

    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