I am planning to apply PAGE compression to some of the big tables in my database (DW to be precise). These tables are fairly big with over 15 Billion rows. When I applied the compression in test environment, the whole process took around 22 hours.These tables are accessed daily with quite long running queries. My questions are
- While the compression is being applied would there be any affect on the queries that are running? Any lock etc I should be aware of?
- Is there a staggered approach to applying compression?
3.Any other input/feedback you might have?