November 16, 2010 at 3:39 pm
I was trying this option in a trail version and would like to know few things with the pros and cons of chosing ROW or PAGE alogirithm.
1. which option would save more space (hope PAGE)
2. which option would give better performance and less I/O botle neck.
3. which option would consume more time for compression
4.which option i would chose i am using this feature everytime when i move a database form 2005 to 2008.
November 17, 2010 at 2:20 am
does anyone here compared these 2 features practically.
November 17, 2010 at 4:19 am
Hi,
I have compared these prior to applying them in the past however this article describes it in detail. The short version of it is, if the table uses a lot of variable length columns then Row level compression will work quite well as it is light weight. If not, page level will work better for you. In general, page level compression will always have a better return.
Also, if your systems suffer from an IO bottleneck but have spare CPU capacity, compression will benefit you in performance by offsetting the IO slightly to the CPU.
Sql Server Performance Article
Thanks,
James
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply