Post reply

Duration for large table compression

  • February 6, 2014 at 6:48 pm

    #303793

    Hi All,

    I have 2 large related ( non partitioned , non heap)tables consuming over 8TB, Recovery mode:Simple and the DB is Sql2008R2 EE). The savings SP reported expected saving of approx 50%. Any hints on predetermining estimated downtime for applying the compression ( REBUILD...with data compression.., ONLINE =OFF).

    Thanks in advance,

    Othman

  • February 6, 2014 at 7:02 pm

    #1686874

    Your best bet is to try that in Dev first.

    While compression is great, I have seen it cause significant slowdowns in queries on very large tables (over 1TB).

    I'd also evaluate just compressing the indexes on the table instead of the heap.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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