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

Kenneth Igiri

SSCertifiable

Points: 5001
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

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

Kenneth Igiri SSCertifiable Points: 5001 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

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:

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 5

akljfhnlaflkj

SSC Guru

Points: 76202

February 17, 2016 at 4:56 pm

#1859437

Thanks for the article.

Del Lee SSCrazy Points: 2781 More actions · Answer 6

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