Post reply

Problems with Data compression in 2008?

  • November 10, 2009 at 6:28 am

    #213767

    Hi,

    We want to compress 2 of our big tables using data compression in SQL server 2008. We have tried page level compression and it reduces the size to 1/6. But we don't know what are the side effects of data compression.

    Has anyone tried this feature? Any known performance or Administration issues?

    -Vikas Bindra

  • November 10, 2009 at 11:35 am

    #1077409

    As with any kind of compression, expect to see a larger amount of CPU time when manipulating this data or doing any kind of re-indexing. Take a look at this MS article if you have time.

  • November 11, 2009 at 12:29 am

    #1077657

    Thanks Crosan for the article. It looks great.

    We ran some tests last night and observed that the INSERTS take 3 time more the time compared to uncompressed table.

    -Vikas Bindra

Viewing 3 posts - 1 through 2 (of 2 total)

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