Solved

Page / Row compression in sql2008

Posted on 2013-01-30
3
173 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
ID: 38838247
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
ID: 38838458
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
ID: 38838745
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Challenging SQL Update 5 44
Better way to make a query with date filter. 5 29
database level memory cache..? 8 18
Job - date manual 1 23
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

825 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