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

Question

Post reply

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

Br. Kenneth Igiri

SSCarpal Tunnel

Points: 4759
More actions
January 17, 2016 at 11:29 pm

#314947

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

Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising

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

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

ianstirk Ten Centuries Points: 1310 More actions · Answer 1

ianstirk

Ten Centuries

Points: 1310

January 18, 2016 at 12:52 am

#1852450

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: 4759 More actions · Answer 2

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
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising

sqlpro Hall of Fame Points: 3859 More actions · Answer 3

sqlpro

Hall of Fame

Points: 3859

January 18, 2016 at 12:46 pm

#1852575

but compression requires enterprise version of sql server, right ?

BTW thanks for the article, very informative.

WAL SSChasing Mays Points: 615 More actions · Answer 4

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: