Analyze what compression type use for table

Asked Aug 17 '16 at 10:20

Active Aug 17 '16 at 10:33

Viewed 55 times

I have SQL Server 2014 database. As size of this database isn't small I want to apply data compression to it. I've used sp_estimate_data_compression_savings to check what how many size I can save and I thought that I should apply that compression type where I can save the most, but... I found this post on msdn where they analyze what type to choose base on 2 more values : Percent of Scan Operations and Percent of Update Operations.

So now I don't know what to choose.

For me it will be more easier if I have same table as in post where they analyze all percentage of compression

edited Aug 17 '16 at 10:33

jarlh

35,821
8
33
49

asked Aug 17 '16 at 10:20

demo

5,376
12
55
130

Maybe the best way in your case use a `column-store indexes` – Devart Aug 17 '16 at 10:29
@Devart, they are supported only in 2016 version, aren't they? – demo Aug 17 '16 at 10:31
1

No :) added from 2012 version – Devart Aug 17 '16 at 10:33
Why can't you provide values for two counters as per DMVs in article ? – TheGameiswar Aug 17 '16 at 10:34
@TheGameiswar, Do you mean I should run 4 queries (estimate for Page, Row compression and for Scan and Update operations)? – demo Aug 17 '16 at 10:56
Yes,in the article referenced ,there are DMVs which gives you counters of U and S values and it also states which values are best,why can't you run them – TheGameiswar Aug 17 '16 at 11:05

Analyze what compression type use for table

0 Answers0