Post reply

Version store does not support page compression

  • August 22, 2017 at 1:51 am

    #328045

    Good Morning Experts,

    Could you please let me know why version store does not support page compression?

  • August 22, 2017 at 2:00 am

    #1956091

    Probably because the CPU overhead and slowdown from such compression would be unacceptable.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 22, 2017 at 11:13 am

    #1956211

    GilaMonster - Tuesday, August 22, 2017 2:00 AM

    Probably because the CPU overhead and slowdown from such compression would be unacceptable.

    Thanks for replying Gail. So, how come version store supports row compression?

  • August 22, 2017 at 11:42 am

    #1956217

    Why are you asking? What problem are you trying to solve that you need to ask that question here and in other places?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 23, 2017 at 5:17 am

    #1956344

    GilaMonster - Tuesday, August 22, 2017 11:42 AM

    Why are you asking? What problem are you trying to solve that you need to ask that question here and in other places?

    I am curious to know the reason Gail.

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

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