Data Compression (Row\Page)

• krdba

  Old Hand

  Points: 372

  More actions

  February 24, 2020 at 4:46 pm

  #3728288

  I'm looking into applying ROW or PAGE Compression to particular indexes and have used the recommended sys.sp_estimate_data_compression_savings and queries to get percentage of scans vs updates.

  Zero updates and large scans are ideal candidates for PAGE compression but what is best if you have the following;

  Page Compression estimate 38%

  Row Compression estimate -10%

  Update % 0

  Scan % 99%

  Does it matter that the ROW compression estimate is negative as I thought ROW is applied before PAGE?  Is that an index to avoid compressing or does the PAGE compression override the negative ROW as only partially full pages will only be ROW compressed and become larger?

  Thanks in advance.

• Site Owners

  SSC Guru

  Points: 80338

  More actions

  February 25, 2020 at 5:10 pm

  #3728665

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.