The Real World: Implementing Data Compression in SQL Server 2008 R2

  • Br. Kenneth Igiri

    SSCarpal Tunnel

    Points: 4521

    Comments posted to this topic are about the item The Real World: Implementing Data Compression in SQL Server 2008 R2

    Br. Kenneth Igiri
    www.scribblingsage.com
    All nations come to my light, all kings to the brightness of my rising

  • ianstirk

    Ten Centuries

    Points: 1310

    Nice article.

    Here's a similar one, but it compresses both tables and indexes:

    www.i-programmer.info/programming/database/5535-a-generic-sql-server-compression-utility.html

    thanks

    Ian

  • Br. Kenneth Igiri

    SSCarpal Tunnel

    Points: 4521

    ianstirk (1/18/2016)


    Nice article.

    Here's a similar one, but it compresses both tables and indexes:

    www.i-programmer.info/programming/database/5535-a-generic-sql-server-compression-utility.html

    thanks

    Ian

    Thanks. Actually SQL Server compression works on indexes too actually. In fact it appears the tool in the URL is built on top of SQL Server compression with a benefit of compression multiple tables and indexes at one.

    Br. Kenneth Igiri
    www.scribblingsage.com
    All nations come to my light, all kings to the brightness of my rising

  • sqlpro

    Hall of Fame

    Points: 3859

    but compression requires enterprise version of sql server, right ?

    BTW thanks for the article, very informative.

  • WAL

    Mr or Mrs. 500

    Points: 594

    Data compression is Enterprise Edition feature. There is a nice article written by MS:

    https://technet.microsoft.com/en-us/library/dd894051(v=sql.100).aspx

    "The data compression feature in the Microsoft® SQL Server® 2008 database software can help reduce the size of the database as well as improve the performance of I/O intensive workloads. However, extra CPU resources are required on the database server to compress and decompress the data, while data is exchanged with the application. Therefore, it is important to understand the workload characteristics when deciding which tables to compress."

    Usually CPU usage increase is negligible after compression. However, you get lots of other benefits out of data compression.

    Buy Enterprise license:hehe:

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the article.

  • Del Lee

    SSCrazy

    Points: 2776

    sqlpro - Monday, January 18, 2016 12:46 PM

    but compression requires enterprise version of sql server, right?

    Since SQL Server 2016sp1, compression is available in all editions.  See this link.



    Del Lee

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

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