Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Compression Expand / Collapse
Author
Message
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?

Specifically:
- 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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 10:17 AM
Points: 31,278, Visits: 15,731
Some people get significant savings, some don't. You'd have to test. There are some scripts here you could use to test (http://blogs.msdn.com/sqlserverstorageengine/archive/2007/11/13/estimating-the-space-savings-with-data-compression.aspx), 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