Home Dashboard Directory Help

Modify sp_estimate_data_compression_savings to allow configurable TableSample rates by Simon Facer



Sign in
to vote
Type: Suggestion
ID: 788325
Opened: 5/21/2013 10:50:48 AM
Access Restriction: Public


Proc sp_estimate_data_compression_savings can provide inaccurate estimates due to large table sizes.
Large tables are commonplace these days, and the current proc attempts to limit the sample to 5000 pages (~39MB), even a table only at 4GB will have a < 1% sample rate.
It is understood that the design of the proc limits the impact on the tested server, but it doesn't allow for reliable estimates on very larger tables.
Sign in to post a comment.
Posted by Microsoft on 6/25/2013 at 1:57 PM
Thank you for submitting this feedback. After carefully evaluating this request, we are closing this item as we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap.
Thanks again for providing the product suggestion and continued support for our product.

Ajay Jagannathan
Senior Program Manager
Posted by app3mxh on 5/21/2013 at 3:11 PM
I think a more flexible sampling option (parameter) is important since we intend to use compression for LARGE table that is most likely much bigger than 1GB in size. 40 MB is rough 4% sample rate. For table greater than 20 GB, it will be less than 0.2%. Please add this feature, otherwise, it can't use it.
Sign in to post a workaround.