Post reply

SQL Server 2016 data compression

  • September 27, 2017 at 1:14 am

    #325559

    SQL Server 2016 SP 1 Standard Edition now supports Data compression! Previously, this was only available in the Enterprise Edition of SQL Server.

    Do we lose any performance if the tables are compressed?

    Because I plan to use it for my DWH

    Thank you

  • October 10, 2017 at 9:12 am

    #1963038

    Compression takes extra CPU. Typically this loss of CPU cycles is made up for by reducing I/O, but that would be something you'd have to test with your system and workload.

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

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