Post reply

Data Compression Objects

  • December 18, 2013 at 11:00 am

    #1674527

    Ford Fairlane (12/17/2013)

    Koen Verbeeck (12/17/2013)

    I have been enabling page compression on our entire data warehouse recently, so this was a pretty easy question 🙂

    Whats your performance been like since ?

    I don't know about Koens perf gains, but I typically see a significant gain in performance. I have seen queries run up to 10x faster with 1/10 the IO. Sure there may be more CPU, but it is for a shorter duration. I'm a little picky in where I compress though.

    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

  • December 24, 2013 at 1:51 am

    #1675739

    Guess what, simple straightforward question for those who read. I was the fortunate one. 🙂

  • December 24, 2013 at 12:15 pm

    #1675821

    nice and easy..

    thanks steve.

  • January 8, 2014 at 12:48 am

    #1678324

    easy one just logical answer after eliminating obviously incorrect ones

Viewing 4 posts - 16 through 18 (of 18 total)

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