Page / Row compression in sql2008

If I decided to enable page/ row compression for few of our huge table,what other side factor I have to take consideration ?

: CPU usage ? how this will impact other session performance ?
: Backup and restore ?
: Mirroring or  replication or even log shipping ? any concern ?
: Memory consumption especially in Buffer pool area ?
Who is Participating?
deviprasadgConnect With a Mentor Commented:
yes it will.

Please refer:

for a sample script to enable and disable compression after truncate.
deviprasadgConnect With a Mentor Commented:
Compression does not affect backup and restore.
Compression does not affect log shipping.

For affects on CPU Usage memory Consuption please refer this link:

For other details please refer this link:
motioneyeAuthor Commented:
I wonder one thing,
If I truncate current data, then start alter table with compression set enable, will newly inserted data get as compressed ?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.