Solved

Page / Row compression in sql2008

Posted on 2013-01-30
3
171 Views
Last Modified: 2013-02-04
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 ?
0
Comment
Question by:motioneye
  • 2
3 Comments
 
LVL 10

Assisted Solution

by:deviprasadg
deviprasadg earned 500 total points
Comment Utility
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
 

Author Comment

by:motioneye
Comment Utility
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
 
LVL 10

Accepted Solution

by:
deviprasadg earned 500 total points
Comment Utility
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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now