Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Database Compression Expand / Collapse
Posted Friday, April 16, 2010 3:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 12, 2014 10:23 PM
Points: 6, Visits: 51
As you all probably know, one of the new features of SQL2008 is database compression. This (could) represent a huge cost savings to our company by reducing the need to purchase expensive SAN equipment. Does anyone out there have any experience with running compressed databases in production environments?

- What kind of database(s) were the? How much space savings did you get?
- What kind of hardware is the DBMS running on?
- Did the compression induce any performance related problems?
- How much effort is it to analyze each table and determine if should be compressed using row compression or page compression.
- At the end of the day was there a net savings after purchasing the SQL2008 license and cutting back disk usage?

Post #905238
Posted Friday, April 16, 2010 4:00 PM



Group: Administrators
Last Login: Yesterday @ 9:28 PM
Points: 34,372, Visits: 18,590
Some people get significant savings, some don't. You'd have to test. There are some scripts here you could use to test (, and you could use Developer edition to run tests.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #905256
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse