Compression Results

I applied page compression to a table in my 2008 r2 database (Enterprise). The table size was reduced by about 3GB. Should I see this reduction in the overall size of the database as well?

more ▼

asked Feb 14, 2014 at 04:51 PM in Default

avatar image

433 34 41 43

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You won't see the physical size of the data file be reduced. You will see that the unused space within the file has gone up.

Ken Simmons has a useful query for viewing used vs. allocated space within database files - http://www.mssqltips.com/sqlservertip/1510/script-to-determine-free-space-to-support-shrinking-sql-server-database-files/

If you think this database will never grow now that you are compressing it, you could shrink the file to give some of the 3GB back to the OS.

If you can work with the current file size, you could should leave it alone and let the database fill the internal empty space without having to auto-grow the file to get back the spaced you would have released with a shrink.

more ▼

answered Feb 14, 2014 at 05:13 PM

avatar image

25k 3 13 20

Thanks Ken! The database will grow, but this particular table is a history table and won't grow at all.

Feb 14, 2014 at 06:59 PM paws27284
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 14, 2014 at 04:51 PM

Seen: 570 times

Last Updated: Feb 14, 2014 at 06:59 PM

Copyright 2018 Redgate Software. Privacy Policy