Home Forums SQL Server 2016 SQL Server 2016 - Administration DB compression with San compression RE: DB compression with San compression

  • February 7, 2018 at 10:29 am

    #1978932

    TheSQLGuru - Wednesday, February 7, 2018 4:36 AM

    I would love to do some playing around with you on this, but with compressed data testing can be somewhat of a mixed bag. If you have (or fabricate) data that fits well into a particular compression scheme things can rock, if not they may not. I am also unbelievably behind on work/life due to some really bad medical issues over the last 8 months. :crying: My time posting on here is something of an escape for me, and even that has been greatly restricted. 

    BTW, I love your vehicular comparison!! 🙂  

    I won't make it to many SQL Saturday's this year, but here's hoping we get the chance to catch up at one anyway.

    Sorry to hear about the health issues. I hope everything is alright or at least on the mend.
    I'll look forward to you getting back on your feet and producing more SQL Saturday content. I think I've seen everything I could find of yours on YouTube... Some, several times.
    As far as testing... I hate to admit it but we have a lot of redundant/flat data that does lend itself to being compressed fairly substantially regardless of the algorithm but I don't know enough about the specific flavors to speak knowledgeably about one versus the other. In any case, I'll leave the offer as an open invitation. Just hit me up if you find a hole in your schedule and want to see how the Pure Storage stacks up against your other benchmarks.

    As far as the vehicular comparison... I'm not much of a car guy but the Koenigseggs are pure art.