Page / Row compression in sql2008

Hi,
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 ?
motioneyeAsked:
Who is Participating?
 
deviprasadgConnect With a Mentor Commented:
yes it will.

Please refer: http://sqlblog.com/blogs/linchi_shea/archive/2008/05/12/sql-server-2008-page-compression-performance-impact-on-inserts.aspx

for a sample script to enable and disable compression after truncate.
0
 
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:
http://msdn.microsoft.com/en-us/library/dd894051.aspx

For other details please refer this link:  
http://technet.microsoft.com/en-us/library/cc280449(v=sql.100).aspx
0
 
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 ?
0
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.